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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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.NTSB WPR13LA212Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Santa Rosa, CAThe partial loss of engine power due to fuel contamination and partially blocked fuel screens.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB WPR12LA437Accident · No injuriesLimited investigationFinal reportMccleery Rans S6ES · Elverta, CAA loss of engine power during initial climb due to a failed piston ring.NTSB WPR12CA400Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Lancaster, CAThe student pilot’s inadvertent selection of an empty fuel tank.NTSB 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.NTSB WPR12CA370Accident · Minor injuriesData collectionFinal reportCessna 150G · Madera, CAThe pilot's mismanagement of the fuel supply, which resulted in fuel exhaustion.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB 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…NTSB WPR12CA072Accident · No injuriesData collectionFinal reportSchweizer SGS 1-26B · Murrieta, CAThe glider's encounter with insufficient atmospheric lift to maintain soaring flight.NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB WPR12LA013Accident · Minor injuriesLimited investigationFinal reportMiller Avid Flyer · Susanville, CAA total loss of engine power during the takeoff climb for undetermined reasons.NTSB 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.NTSB 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.NTSB 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.NTSB 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.NTSB WPR11LA374Accident · Minor injuriesLimited investigationFinal reportSIAI Marchetti F.260 · Coalinga, CAA partial loss of engine power immediately after takeoff for undetermined reasons.NTSB 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…NTSB 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.NTSB 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.NTSB 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.NTSB WPR11LA284Accident · No injuriesLimited investigationFinal reportCessna 172S · Palo Alto, CAA total loss of engine power for undetermined reasons during the landing approach over unsuitable terrain.NTSB 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.NTSB 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.NTSB WPR11LA244Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Stockton, CAThe pilot's failure to maintain clearance from obstacles.