NTSB investigations, CA

304 cases where the sequence of events included Off-field or emergency landing.

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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '440' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  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 WPR13LA216Accident · Minor injuriesLimited investigationFinal reportRans S-17 · Fontana, CAA loss of engine power due to improper construction and inadequate maintenance of the fuel system and engine. Contributing to the accident was the airplane’s inadvertent contact with an unseen guy wire during the landing flare.May 4, 2013 · N6171R · Substantial damageNTSB WPR13LA212Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Santa Rosa, CAThe partial loss of engine power due to fuel contamination and partially blocked fuel screens.Apr 20, 2013 · N985SS · Substantial damageNTSB WPR13CA218Accident · No injuriesData collectionFinal reportSchleicher ASW-27 · Middletown, CAThe glider’s encounter with atmospheric lift conditions not sufficient to maintain flight, which resulted in a forced landing on rough terrain.Apr 12, 2013 · N503CW · Substantial damageNTSB WPR13CA163Accident · Minor injuriesData collectionFinal reportCessna 172G · Temecula, CAThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.Mar 22, 2013 · N5931R · Substantial damageNTSB WPR13IA144Incident · No injuriesIncident investigationFinal reportBombardier DHC-8-402 · Danville, CAThe failure and separation of a section of the No. 2 engine's combustion chamber's small exit duct (SED), which created an airflow disruption that led to an engine surge and subsequent fire. Contributing to the accident was the insufficient weld penetration…Mar 5, 2013 · N417QX · Minor damageNTSB WPR13CA103Accident · No injuriesData collectionFinal reportCessna 150J · Porterville, CAThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.Jan 18, 2013 · N50690 · Substantial damageNTSB WPR13LA087Accident · Serious injuriesLimited investigationFinal reportBell OH-58C · Riverdale, CAA flight control malfunction while maneuvering for reasons that could not be determined because it was not possible to establish whether observed damage to the flight control assembly was the result of wreckage recovery efforts or a preexisting condition.Jan 8, 2013 · N911PT · Substantial damageNTSB WPR13LA085Accident · Minor injuriesLimited investigationFinal reportJeremiah Jackson Vans RV-10 · Julian, CAA loss of engine power due to oil starvation as a result of a disconnected oil line. Contributing to the accident was an insufficiently tightened oil line fitting.Jan 5, 2013 · N262NJ · Substantial damageNTSB WPR13LA052Accident · Minor injuriesLimited investigationFinal reportCessna U206 · Van Nuys, CAA partial loss of engine power during cruise flight due to fatigue fractures of two crankshaft gear teeth from corrosion pitting, which resulted in an off-airport forced landing and collision with obstacles on the ground.Nov 25, 2012 · N5229U · Substantial damageNTSB WPR13LA047Accident · No injuriesLimited investigationFinal reportCessna 210 · San Rafael, CAThe loss of engine power during initial climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Nov 20, 2012 · N3919Y · Substantial damageNTSB WPR13LA009Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Corona, CATotal loss of engine power during the landing approach due to insect debris in the carburetor metering valve, which resulted in fuel starvation.Oct 13, 2012 · N4309E · Substantial damageNTSB WPR12LA437Accident · No injuriesLimited investigationFinal reportMccleery Rans S6ES · Elverta, CAA loss of engine power during initial climb due to a failed piston ring.Sep 25, 2012 · N623LB · Substantial damageNTSB WPR12CA400Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Lancaster, CAThe student pilot’s inadvertent selection of an empty fuel tank.Sep 4, 2012 · N308DF · Substantial damageNTSB WPR12LA394Accident · No injuriesLimited investigationFinal reportBellanca 14-19-3 · Healdsburg, CAThe loss of engine power during cruise flight due to the failure of the engine-driven fuel pump as a result of unidentified debris within the vapor return jet.Aug 30, 2012 · N1299R · Substantial damageNTSB WPR12CA370Accident · Minor injuriesData collectionFinal reportCessna 150G · Madera, CAThe pilot's mismanagement of the fuel supply, which resulted in fuel exhaustion.Aug 26, 2012 · N6346S · Substantial damageNTSB WPR12CA350Accident · No injuriesData collectionFinal reportCessna 152 · Eastvale, CAThe failure of both pilots to ensure that no water was present in the fuel, which resulted in a complete loss of engine power and a forced off-field landing.Aug 10, 2012 · N94185 · Substantial damageNTSB WPR12CA340Accident · Minor injuriesData collectionFinal reportPiper PA-22-160 · McKinleyville, CAThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel starvation. Contributing to the accident were the pilot’s lack of experience in the accident airplane make and model and his lack of knowledge regarding the fuel system.Aug 2, 2012 · N3442Z · Substantial damageNTSB WPR12FA316Accident · Serious injuriesField investigationFinal reportCessna 182P · Corona, CAA loss of engine power shortly after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the pilot’s decision to take off…Jul 21, 2012 · N640AM · Substantial damageNTSB WPR12LA281Accident · No injuriesLimited investigationFinal reportTecnam P2002 Sierra · Watsonville, CAA partial loss of engine power during initial climb due to the blockage of the carburetor’s main jet by deteriorated float material. Contributing to the accident was an inadequate maintenance inspection by maintenance personnel.Jun 30, 2012 · N308TA · Substantial damageNTSB WPR12CA278Accident · No injuriesData collectionFinal reportSchweizer SGS 1-36 · Bishop, CAThe glider’s encounter with insufficient atmospheric lift to maintain soaring flight, which resulted in an off-airport landing.Jun 27, 2012 · N3617U · Substantial damageNTSB WPR12LA275Accident · No injuriesLimited investigationFinal reportDehavilland Tiger Moth DH 82A · Fontana, CAPartial loss of engine power during cruise flight due to a failed engine cylinder rocker assembly clamping bolt. Contributing to the accident was the failure of unknown maintenance personnel to perform a modification to the assembly that would have prevented…Jun 24, 2012 · N523R · Substantial damageNTSB WPR12LA253Accident · Minor injuriesLimited investigationFinal reportCessna 172B · San Andreas, CAA loss of engine power in cruise flight for reasons that could not be determined because a postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.Jun 9, 2012 · N7458X · Substantial damageNTSB WPR12LA264Accident · No injuriesLimited investigationFinal reportLuscombe 8 · Twentynine Palms, CAA loss of engine power during initial climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.May 29, 2012 · N2435K · Substantial damageNTSB WPR12LA233Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Wilton, CAThe failure of the hopper gate mechanism and subsequent sulfur fire during a low-level maneuver.May 27, 2012 · N8380 · Substantial damageNTSB WPR12LA201Accident · Minor injuriesLimited investigationFinal reportBeech 3NM · Pope Valley, CAA loss of power in one engine during takeoff, which resulted in a forced landing in a vineyard. The reason for the loss of engine power could not be determined from the available evidence.May 12, 2012 · N9540 · Substantial damageNTSB WPR12LA185Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Cloverdale, CAThe pilot’s improper fuel management, which resulted in a loss of engine power during climb due to fuel starvation.Apr 27, 2012 · N80SV · Substantial damageNTSB WPR12CA166Accident · Minor injuriesData collectionFinal reportMooney M20B · Rosamond, CAA loss of engine power during takeoff due to fuel starvation as a result of the pilot’s selection of an empty fuel tank prior to departure.Apr 15, 2012 · N74518 · Substantial damageNTSB WPR12LA141Accident · No injuriesLimited investigationFinal reportGrimm RV-9A · Santa Maria, CAA partial loss of engine power during cruise flight for reasons that could not be determined because postaccident examination and testing did not reveal any anomalies that would have precluded normal operation.Mar 20, 2012 · N629BJ · Substantial damageNTSB WPR12LA140Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Palo Alto, CAThe pilot's improper use of the throttle grip, which resulted in the deactivation of the rpm governor and a loss of rotor rpm.Mar 15, 2012 · N290SH · Substantial damageNTSB WPR12LA128Accident · No injuriesLimited investigationFinal reportBeech 76 · Rio Linda, CAA loss of engine power due to carburetor icing, and the pilot's failure to use carburetor heat during descent while operating in an area conducive to carburetor icing.Mar 11, 2012 · N6697L · Substantial damageNTSB WPR12LA081Accident · Minor injuriesLimited investigationFinal reportMas Events Nemesis · Camarillo, CAA partial loss of engine power during cruise flight due to incorrectly installed airframe components, which came into contact with a high pressure fuel line and resulted in its failure. Contributing to the accident was an undetermined failure of the primary…Jan 24, 2012 · F-WNXT · Substantial damageNTSB WPR12CA072Accident · No injuriesData collectionFinal reportSchweizer SGS 1-26B · Murrieta, CAThe glider's encounter with insufficient atmospheric lift to maintain soaring flight.Dec 28, 2011 · N8641R · Substantial damageNTSB WPR12LA055Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Davis, CAThe pilot's inadequate fuel management, which resulted in a loss of engine power due to fuel starvation.Dec 7, 2011 · N2466D · Substantial damageNTSB WPR12LA032Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Williams, CAA total loss of engine power during takeoff initial climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Nov 8, 2011 · N325BR · Substantial damageNTSB WPR12LA022Accident · Minor injuriesLimited investigationFinal reportMcdonnell Douglas 500D · Colusa, CAA total loss of engine power while maneuvering at low altitude for reasons that could not be determined because postaccident examinations did not reveal any anomalies that would have precluded normal operation. Contributing to the accident severity was the…Oct 27, 2011 · N61PJ · Substantial damageNTSB WPR12LA015Accident · Minor injuriesLimited investigationFinal reportPiper PA46R · Paso Robles, CAA loss of engine power while maneuvering for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Oct 21, 2011 · N422HP · Substantial damageNTSB WPR12LA013Accident · Minor injuriesLimited investigationFinal reportMiller Avid Flyer · Susanville, CAA total loss of engine power during the takeoff climb for undetermined reasons.Oct 15, 2011 · N4077B · Substantial damageNTSB WPR11LA410Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Napa, CAThe pilot’s mismanagement of the fuel supply, which resulted in a loss of engine power due to fuel starvation.Aug 28, 2011 · N6052W · Substantial damageNTSB WPR11CA411Accident · Serious injuriesData collectionFinal reportSchweizer SGS 2-32 · Warner Springs, CAThe pilot’s inadequate altitude to clear a ridgeline while maneuvering over a mountainous area.Aug 28, 2011 · N5840V · Substantial damageNTSB WPR11FA403Accident · No injuriesField investigationFinal reportBeech A23-24 · Palo Alto, CAThe student’s and flight instructor’s mismanagement of the fuel supply, resulting in a total loss of engine power due to fuel starvation.Aug 23, 2011 · N5779V · Substantial damageNTSB WPR11LA380Accident · No injuriesLimited investigationFinal reportBeech B36TC · Lemoore, CAA loss of engine power during cruise flight due to maintenance personnel's failure to adequately torque the number 4 cylinder retaining nuts, which resulted in the in-flight separation of the cylinder.Aug 14, 2011 · N6465X · Substantial damageNTSB WPR11LA374Accident · Minor injuriesLimited investigationFinal reportSIAI Marchetti F.260 · Coalinga, CAA partial loss of engine power immediately after takeoff for undetermined reasons.Aug 7, 2011 · N408FD · Substantial damageNTSB WPR11LA373Accident · No injuriesLimited investigationFinal reportRotorway Exec · Chino Hills, CAA total loss of engine power due to fuel exhaustion as a result of both the owner's and the pilot's failure to determine or monitor the remaining fuel quantity during the flight. Contributing to the accident was the manufacturer's lack of fuel consumption…Aug 6, 2011 · N162CT · Substantial damageNTSB WPR11LA320Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Yuba City, CAHigh-cycle fatigue on the 1st-stage compressor blade retaining ring, which resulted in the ring’s fracture and a subsequent loss of engine power.Jul 9, 2011 · N7503L · Substantial damageNTSB WPR11LA318Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Frazier Park, CAThe pilot’s geographic disorientation, which resulted in an off-airport precautionary landing in soft terrain and a subsequent nose over.Jul 8, 2011 · N4901Z · Substantial damageNTSB WPR11LA311Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Hesperia, CAThe separation of the end baffle cone inside the muffler, which blocked airflow through the engine after takeoff and resulted in a loss of engine power and an off-airport landing into obstacles.Jul 6, 2011 · N7392X · Substantial damageNTSB WPR11LA284Accident · No injuriesLimited investigationFinal reportCessna 172S · Palo Alto, CAA total loss of engine power for undetermined reasons during the landing approach over unsuitable terrain.Jun 24, 2011 · N222MF · Substantial damageNTSB WPR11LA279Accident · Serious injuriesLimited investigationFinal reportRockwell International S-2R · Brawley, CAThe partial loss of engine power shortly after takeoff, which likely resulted from the failure of the piston connecting rod in cylinder number 3 due to hydraulic lock in that cylinder.Jun 23, 2011 · N8520V · Substantial damageNTSB WPR11LA254Accident · No injuriesLimited investigationFinal reportCessna 177 · Santa Clarita, CAThe pilot's inadequate preflight verification of the fuel quantity and his inadequate fuel consumption calculations, which resulted in fuel exhaustion.Jun 9, 2011 · N2301Y · Substantial damageNTSB WPR11LA244Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Stockton, CAThe pilot's failure to maintain clearance from obstacles.Jun 1, 2011 · N68012 · Substantial damage