NTSB investigations: NONE, CA

297 cases on aircraft whose registry engine model is NONE. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Cases, newest first

Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
  FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
  WHERE c.\"eventStateOrRegion\" = 'CA' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('00000'))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

NTSB LAX06CA189Accident · No injuriesData collectionFinal reportBurkhart Grob Flugzeugbau G103 Twin Astir · Llano, CAthe student pilot's failure to recover from a porpoise/pilot induced oscillation, which resulted in a hard landing.Jun 3, 2006 · N4464P · Substantial damageNTSB SEA07CA138Accident · No injuriesData collectionFinal reportSchleicher ASW-24 · Williams, CAThe loss of thermal lift during cruise flight that resulted in a forced landing.May 27, 2006 · N5LX · Substantial damageNTSB LAX06CA046Accident · No injuriesData collectionFinal reportCameron Balloons N-180 · Rancho Santa Fe, CAthe pilot's inadvertent deactivation of the number 2 burner, which resulted in an increased rate of descent and a collision with a tree short of the intended landing zone.Nov 26, 2005 · N4506B · Substantial damageNTSB LAX06CA021Accident · Minor injuriesData collectionFinal reportDirks Glaser DG-300 · California City, CAthe pilot's inadvertent retraction of the gear and failure to deploy the spoilers, and his subsequent failure to attain a proper touchdown point.Oct 29, 2005 · N30AS · DestroyedNTSB LAX05LA224Accident · 1 fatalLimited investigationFinal reportSchleicher ASW-20 · Big Pine, CAthe pilot's failure to maintain an adequate terrain clearance altitude and his decision to turn toward higher terrain.Jul 3, 2005 · N31AP · DestroyedNTSB LAX05CA190Accident · No injuriesData collectionFinal reportS.A. Centrair Pegase 101D · Williams, CAloss of thermal lift during flight that resulted in a forced landing in an area without suitable landing terrain. Also causal was the pilot's inadequate compensation for the existing crosswind.May 28, 2005 · N70LE · Substantial damageNTSB LAX05LA162Accident · Serious injuriesLimited investigationFinal reportUltramagic N-250 · Del Mar, CAThe pilot's failure to arrest the high rate of descent and an inadequate bounced landing recovery technique. a factor in the accident was the rough, uneven terrain.May 9, 2005 · N3002J · No damageNTSB LAX05LA143Accident · Serious injuriesLimited investigationFinal reportFirefly Balloon Firefly 11 · Saint Helena, CAThe pilot's encounter with wind shear during landing, which resulted in a hard touchdown.Apr 13, 2005 · N15001 · No damageNTSB LAX04CA270Accident · No injuriesData collectionFinal reportPdps Pzl-Bielsko SZD-50-3 · Lone Pine, CAthe pilot failed to maintain runway alignment, and misjudged the clearance between the tree and the wing resulting in a collision with the tree.Jul 18, 2004 · N19SZ · Substantial damageNTSB LAX03LA291Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth Standard Cirrus · Lone Pine, CAthe pilot's inadequate assembly of the glider and improper preflight inspection, which resulted in an inadvertent deployment of the spoilers. Also causal was the pilot's failure to maintain obstacle clearance. His diverted attention to the control problems…Sep 19, 2003 · N71DA · Substantial damageNTSB LAX03CA277Accident · Minor injuriesData collectionFinal reportPZL PW-5 · Yreka, CAthe pilot's inadequate in-flight planning/decision and failure to maintain airspeed resulted in an inadvertent stall. A factor in the accident was the downdraft.Aug 30, 2003 · N105PS · Substantial damageNTSB LAX03CA201Accident · Minor injuriesData collectionFinal reportSchleicher ASW-20 · Idyllwild, CAThe combined effects of a loss of thermal lift and a gust induced loss of airspeed at a low above ground altitude, which resulted in a descent to impact with trees. The pilot's failure to maintain an adequate terrain clearance margin while cruising in…Jun 15, 2003 · N34LB · Substantial damageNTSB LAX03LA133Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-34 · San Diego, CAthe pilot's misjudgment of the landing flare and descent rate. A contributing factor was the pilot's misjudged speed and distance.Mar 16, 2003 · N1169S · Substantial damageNTSB LAX03LA114Accident · No injuriesLimited investigationFinal reportSchleicher ASW-20 · San Diego, CAthe pilot's use of an inadequate climb attitude during takeoff resulting in the proper climb rate not being established.Mar 16, 2003 · N31AP · Substantial damageNTSB LAX03LA097Accident · 1 fatalLimited investigationFinal reportFirefly 11B · Yountville, CAA bystander was impaired by drugs and did not follow the pilot's directive to release the balloon as it began its ascent.Feb 25, 2003 · N1501H · No damageNTSB LAX02LA291Accident · 1 fatalLimited investigationFinal reportPZL-Bielsko SZD-42-2 Jantar · Hemet, CAthe pilot's failure to maintain an adequate terrain clearance altitude.Sep 21, 2002 · N131AS · Substantial damageNTSB LAX02LA261Accident · Minor injuriesLimited investigationFinal reportAB Sportine Aviacija Genesis 2 · Orland, CAthe loss of thermal lift during flight.Aug 23, 2002 · N422DT · Substantial damageNTSB LAX02LA208Accident · Serious injuriesLimited investigationFinal reportWSK PZL Swidnik PW-5 · Loch Lomand, CAthe pilot's inadequate compensation for wind conditions, and his failure to maintain clearance with trees during final approach. A contributing factor was the windshear and turbulence encountered during the approach.Jun 23, 2002 · N115TM · Substantial damageNTSB LAX02LA150Accident · Serious injuriesLimited investigationFinal reportThunder and Colt Colt 120 A · Moreno Valley, CAThe pilot's inadequate handling of the aircraft. High winds were a contributing factor.Feb 23, 2002 · N240TC · No damageNTSB LAX02LA079Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Warner Springs, CAThe student pilot's failure to maintain directional control during the landing sequence.Feb 4, 2002 · N34292 · Substantial damageNTSB LAX02LA042Accident · Serious injuriesLimited investigationFinal reportBurkhart Grob G102 Club Astir Iiib · Banning, CAOn final approach, the pilot's failure to maintain adequate aircraft airspeed and control during an encounter with the gusting high wind.Dec 7, 2001 · N102FC · Substantial damageNTSB LAX01LA038Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 1-36 · Lake Elsinore, CAThe pilot's misjudged altitude approaching the airstrip and his failure to maintain airspeed resulted in the glider's collision with trees.Nov 11, 2000 · N3621R · Substantial damageNTSB LAX00LA240Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 1-26C · Tehachapi, CAThe pilot's failure to maintain aircraft speed and control while maneuvering to land.Jun 23, 2000 · N2792Z · Substantial damageNTSB LAX99LA285Accident · No injuriesLimited investigationFinal reportBurkhart Grob G 103 Twin II · Llano, CAThe pilot's encounter with a sudden and violent dust devil, which caused the student pilot to lose control of the aircraft during the landing flare/touchdown.Aug 23, 1999 · N8013K · Substantial damageNTSB LAX99LA228Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Barstow, CAThe loss of thermal lift that resulted in a forced landing and the pilot's improper glide path that resulted in a collision with a light pole.Jun 19, 1999 · N136AS · Substantial damageNTSB LAX99LA189Accident · Serious injuriesLimited investigationFinal reportCameron A-250 · Windsor, CAThe pilot did not obtain the most current weather briefing available, which forecast high winds about his actual landing time. The balloon encountered high winds and collided with an embankment in a field during a precautionary hard landing. Factors in the…May 22, 1999 · N3037V · Substantial damageNTSB LAX98LA092Accident · No injuriesLimited investigationFinal reportSchempp-Hirth VENTUS-B · Williams, CAThe pilot's failure to maintain an adequate clearance from the oil drilling rig due to his attention being diverted inside the cockpit in order the secure the landing gear control.Feb 23, 1998 · N948B · Substantial damageNTSB LAX98LA005Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 11 · Rancho Bernardo, CAThe pilot's intentional flight in high wind conditions and his improper in-flight planning.Oct 11, 1997 · N2585Z · Minor damageNTSB LAX98FA007Accident · 1 fatalField investigationFinal reportSchweizer 2-32 · Warner Springs, CAthe pilot's inadvertent flight into instrument meteorological conditions after inadvertently encountering mountain wave and associated downdraft conditions. The obscuration and high/mountainous terrain were related factors.Oct 11, 1997 · N242DB · Substantial damageNTSB LAX97LA227Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G-103-TWIN II · Jacumba, CAThe pilot's abrupt rotation, which resulted in the breaking of the tow rope. A factor was the low altitude when the tow rope broke, precluding a landing on the runway.Jun 30, 1997 · N18AG · Substantial damageNTSB LAX97LA159Accident · Serious injuriesLimited investigationFinal reportHead Balloons AX8-88 · San Diego, CAThe pilot's decision to increase sink rate to avoid flying into an obstacle with insufficient altitude remaining to reduce the sink rate prior to impact with the ground.Apr 14, 1997 · N380P · Substantial damageNTSB LAX97LA160Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Llano, CAthe student pilot's inadequate compensation for the crosswind condition, and his failure to maintain proper altitude and clearance from the boundry fence, during an approach to land on the runway. Factors relating to the accident were: the crosswind, and…Apr 12, 1997 · N2037T · Substantial damageNTSB LAX97LA024Accident · No injuriesLimited investigationFinal reportSchweizer 2-33-A · Los Alamitos, CAThe student pilot's failure to properly handle the glider, and the instructor pilot's inadequate supervision.Oct 20, 1996 · N65844 · Substantial damageNTSB LAX96LA343Accident · No injuriesLimited investigationFinal reportAero Commander 690 · Truckee, CAThe inadequate visual outlook by both pilots while in the vicinity of the airport. A factor was that each aircraft was on a different frequency at the time.Sep 20, 1996 · N840DC · 2 aircraft · Substantial damageNTSB LAX96LA330Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G102 · Warner Springs, CAimproper planning/decision by the pilot concerning a low altitude release to return to the airport after takeoff. Factors relating to the accident were: the pilot's inadequate preflight by failing to ensure that the yaw indicator string movement was free,…Sep 9, 1996 · N3950B · Substantial damageNTSB LAX96LA218Accident · No injuriesLimited investigationFinal reportSchweizer 1-24 · Tehachapi, CAthe glider pilot's decision to land on the grass covered infield instead of the alternate runway, and the pilot's failure to maintain directional control. Contributing to the accident was the pilot's improper use of the spoilers and brakes.May 25, 1996 · N91888 · Substantial damageNTSB LAX96LA160Accident · No injuriesLimited investigationFinal reportSchweizer SGS1-34 · Inyokern, CAthe pilot misjudged altitude while maneuvering in mountainous terrain. Contributing factors were: the pilot's inadequate in-flight planning and the lack of available thermal lift over the rapidly rising rough terrain.Apr 7, 1996 · N7623 · Substantial damageNTSB LAX96LA144Accident · No injuriesLimited investigationFinal reportEiriavion PIK 20D · Hollister, CAthe pilot's improper in-flight decision to take a longer than necessary route back to the airport during a period of marginal lift.Mar 23, 1996 · N4HT · Substantial damageNTSB LAX96LA089Accident · No injuriesLimited investigationFinal reportAerostar RX-8 · Lucerne Valley, CAthe balloon's encounter with unexpected high wind conditions, and the pilot's inability to stop the balloon prior to contacting ground obstructions.Dec 30, 1995 · N70107 · Substantial damageNTSB LAX96LA060Accident · Serious injuriesLimited investigationFinal reportLaister LP-15 · Adelanto, CAthe pilot's selection of the wrong runway for the prevailing wind conditions, and his failure to maintain an adequate airspeed during the base-to-final turn.Dec 1, 1995 · N6LS · DestroyedNTSB LAX95LA311Accident · Serious injuriesLimited investigationFinal reportElan Glaser Dirks DG-300 Elan · Truckee, CAthe pilot misjudged his planned approach by selecting a touchdown point close to the runway's approach end that did not provide sufficient clearance to safely maneuver when forcast turbulence and downdrafts were encountered. The pilot's early extension of…Aug 28, 1995 · N300HX · Substantial damageNTSB LAX95LA305Accident · No injuriesLimited investigationFinal reportSikorsky CH-54A · Emigrant Gap, CAa compressor stall in the right engine for an unknown reason, which resulted in a loss of power in that engine; and inadequate crew coordination between the pilot and copilot, which resulted in their failure to ensure that the external load was promptly…Aug 26, 1995 · N64AR · DestroyedNTSB LAX95LA242Accident · No injuriesLimited investigationFinal reportMiller, Terry W. Tern · Adelanto, CAthe pilot's inadequate compensation for the existing wind conditions.Jul 1, 1995 · N7322 · Substantial damageNTSB LAX95LA050Accident · No injuriesLimited investigationFinal reportBurkhart Grob G-103 · Tehachapi, CAthe pilot's poor in-flight planning/decision and inadequate airspeed. The downdraft and trees were factors in this accident.Dec 11, 1994 · N3950A · Substantial damageNTSB LAX94LA259Accident · Serious injuriesLimited investigationFinal reportMascari Discovery S-12 · Salinas, CAThe failure of the muffler assembly due to preexisting cracking in the oxidized area of the weld, with subsequent damage and separation of the propeller and reduction gear box. A related factor was the excessive taxispeed which resulted in the airplane…Jun 18, 1994 · N999 · DestroyedNTSB LAX94LA244Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8 · Acton, CAthe pilot's improper in-flight planning and his misjudging the wind speed information. Contributing factors were the gusty winds and the lack of suitable terrain.Jun 5, 1994 · N9084D · Substantial damageNTSB SEA94LA118Accident · No injuriesLimited investigationFinal reportMaule M-5-235C · Columbia, CAThe pilot in command's failure to maintain directional control. The crosswind was a factor.May 13, 1994 · N711CX · Substantial damageNTSB LAX94LA102Accident · 1 fatalLimited investigationFinal reportFurche-Bielsko SZD-48 Jantar · Warner Springs, CAThe pilot's improper remedial action to recover from the spin. The intentional stall/spin was a factor in this accident.Jan 22, 1994 · N48DF · DestroyedNTSB LAX93LA347Accident · No injuriesLimited investigationFinal reportCameron V-77 · Truckee, CAthe pilot's inadequate compensation for the wind conditions during the landing approach.Sep 5, 1993 · N2021A · Substantial damageNTSB LAX93LA326Accident · Serious injuriesLimited investigationFinal reportPilatus B4-PC11AF · Truckee, CAFailure of the pilot to conduct adequate preflight checks which resulted in the glider taking off with a frayed release hook cable, the pilot's failure to maintain airspeed, and the inadvertent stall.Aug 17, 1993 · N205AS · Substantial damage