NTSB investigations
3,372 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.\"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."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 WPR09GA119Accident · Serious injuriesFinal reportMcdonnell Douglas Helicopter 600 · San Clemente, CAFailure of the engine’s number two bearing during cruise flight, which resulted in a loss of engine power.NTSB WPR09CA121Accident · Minor injuriesData collectionFinal reportCessna 182 · Caldwell, IDThe loss of engine power due to carburetor icing as a result of the pilot's failure to apply carburetor heat before reducing power and his failure to clear the engine during a prolonged glide.NTSB WPR09LA117Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Turlock, CAThe loss of engine power due to carburetor icing resulting from the pilot's failure to apply carburetor heat. Contributing to the accident was the instructor's inadequate supervision of the flight.NTSB WPR09CA118Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta II · Encinitas, CAA partial loss of engine power for an undetermined reason. Contributing to the accident was the soft terrain.NTSB ERA09LA163Accident · Serious injuriesLimited investigationFinal reportPiper PA28 · Pittstown, NJA loss of engine power due to the improper tightening of a fuel hose B-nut by maintenance personnel during engine installation.NTSB WPR09CA113Accident · Minor injuriesData collectionFinal reportCessna 172D · Bow, WAA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate preflight inspection and failure to verify the fuel quantity on board.NTSB ERA09LA151Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Cameron, SCA loss of engine power for undetermined reasons.NTSB ERA09CA149Accident · No injuriesData collectionFinal reportD-Fly UL Stork · Jackson, GAThe pilot's inadvertent activation of an engine cutoff switch during cruise flight.NTSB CEN09LA145Accident · Minor injuriesLimited investigationFinal reportCessna 421C · Wichita, KSThe failure of line personnel to ensure that the airplane was serviced with the proper fuel. Contributing to the accident was the Federal Aviation Administration's approval of a Supplemental Type Certificate (STC) which allowed an improper fuel filler…NTSB WPR09FA102Accident · 2 fatalField investigationFinal reportSiai-Marchetti SF-260C · Santa Monica, CAThe pilot’s failure to select the proper fuel tank for takeoff, which resulted in a loss of engine power. Contributing to the accident was the pilot's failure to maintain aircraft control while attempting a return to runway maneuver.NTSB ERA09IA140Incident · No injuriesIncident investigationFinal reportCessna 402C · Naples, FLThe pilot's failure to recognize that both engines were being supplied fuel only from the right main fuel tank, resulting in fuel starvation and a subsequent loss of engine power from both engines. Contributing to the incident were the pilot's inability to…NTSB CEN09LA143Accident · No injuriesLimited investigationFinal reportCessna 172E · Plano, TXA loss of engine power in flight due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB WPR09LA097Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Honolulu, HIAn oil starvation induced catastrophic engine failure due to the fracture and separation of the propeller governor oil line, which was a result of inadequate inspection by maintenance personnel.NTSB WPR09CA092Accident · No injuriesData collectionFinal reportRyan Navion · Three Forks, MTA total loss of engine power due to fuel starvation as a result of the pilot's inadequate fuel system management. Contributing to the accident were the pilot's diverted attention and failure to perform the prelanding checklist.NTSB WPR09CA091Accident · No injuriesData collectionFinal reportSiemer James H Earthstar · Santa Ynez, CAA partial loss of engine power due to the rear cylinder's spark plug coming out of the cylinder head.NTSB WPR09CA090Accident · Minor injuriesData collectionFinal reportMulec Frank A FP-404 · Hilo, HIA total loss of engine power due to fuel starvation as a result of a clogged fuel filter.NTSB ERA09LA146Accident · No injuriesLimited investigationFinal reportCessna 152 · Wauchula, FLA loss of engine power due to failure of the Number 3 connecting rod due to oil contamination. Contributing to the accident was the insufficient oil change time intervals performed by company personnel.NTSB WPR09LA085Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Beaver, UTA loss of engine power while maneuvering due to a sheared propeller blade's pitch change link. Contributing to the accident was lack of suitable terrain for the forced landing.NTSB WPR09LA082Accident · Minor injuriesLimited investigationFinal reportStits Flut-R-Bug SA6B · Los Olivos, CAA loss of engine power for undetermined reasons. Contributing to the accident was the pilot's improper decision to depart from a road with a known unresolved engine problem.NTSB WPR09CA078Accident · Minor injuriesData collectionFinal reportCessna 150L · Pescadero, CAThe pilot's inadequate preflight fuel planning and preparation. Contributing to the accident was the lack of a suitable area for a forced landing.NTSB WPR09LA077Accident · No injuriesLimited investigationFinal reportCessna R172K · Fremont, CAThe partial loss of engine power during takeoff due to an oil pump/tachometer drive gear failure for undetermined reasons.NTSB CEN09LA124Accident · Minor injuriesLimited investigationFinal reportLavigna Lancair IV P · Iola, KSThe total loss of engine power for undetermined reasons.NTSB WPR09LA075Accident · No injuriesLimited investigationFinal reportCzech Aircraft Works Sport Cruiser · Casa Grande, AZThe pilot's failure to ensure that the canopy was latched prior to takeoff. Contributing to the accident was the inadequate guidance in the Pilot Operating Handbook regarding canopy procedures.NTSB CEN09LA132Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA-5B · Milford, INA loss of engine thrust due to the separation of a section of one of the propeller blades as a result of fatigue failure of the propeller because of corrosion. Contributing to the accident was the failure of the mechanic to detect and address the propeller…NTSB CEN09CA123Accident · No injuriesData collectionFinal reportCessna T210M · Fort Collins, COA total loss of engine power due to fuel starvation as a result of the pilot's failure to select the fullest tank before landing.NTSB ERA09LA114Accident · No injuriesLimited investigationFinal reportJohnson Barron T Lancair 360 · Owensboro, KYThe loss of engine power due to fuel starvation. Contributing to the accident was the failure of the fuel selector valve cotter pin and the inoperative main (center) fuel tank gauge.NTSB CEN09LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Santo Domingo Pueblo, NMA loss of engine power due a loss of oil pressure resulting in heat distress and mechanical failure of the engine. The reason for the loss of oil pressure was not determined.NTSB ERA09LA109Accident · No injuriesLimited investigationFinal reportMichel Paul John Murphy Rebel · Live Oak, FLA partial loss of engine power for undetermined reasons.NTSB CEN09CA104Accident · No injuriesData collectionFinal reportMooney M20C · Edgewood, NMA total loss of engine power while at cruise altitude for undetermined reasons.NTSB ERA09LA107Accident · Minor injuriesLimited investigationFinal reportMoore David DM-1 · Salters, SCA hard landing following an autorotation that resulted from the separation of the red main rotor blade cap that led to the uncontrolled movement of the cyclic, autorotation and a hard landing.NTSB ERA09LA105Accident · Serious injuriesLimited investigationFinal reportBell 407 · Bow, NHAn interruption of fuel flow for undetermined reasons, which resulted in an engine flameout.NTSB ERA09LA098Accident · Minor injuriesLimited investigationFinal reportHess John L Spezio II · Newville, PAA loss of engine power due to carburetor ice as a result of the pilot's delayed use of carburetor heat.NTSB ERA09FA093Accident · 1 fatalField investigationFinal reportBeech 36 · Louisville, KYThe pilot’s continued operation of the aircraft with known deficiencies. Contributing to this accident was the improper sealing of the engine case during overhaul.NTSB WPR09CA064Accident · No injuriesData collectionFinal reportAir Tractor AT-502 · Dinuba, CAThe failure of maintenance personnel to properly install the engine's Py line correctly, which resulted in the total loss of engine power and subsequent force landing. Contributing to the accident was the lack of suitable terrain.NTSB ERA09LA096Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · New Bern, NCA loss of engine power for undetermined reasons.NTSB CEN09IA096Incident · No injuriesIncident investigationFinal reportCessna 182 · Fort Worth, TXCollision with a hidden obstruction while taxiing through a grass field following a forced landing. Contributing to the accident was a loss of engine power due to the pilot's failure to turn on the carburetor heat.NTSB ERA09LA081Accident · No injuriesLimited investigationFinal reportMerrell Stephen F1 Rocket · Sebastian, FLA loss of engine power due to fuel starvation as a result of the pilot's incorrect positioning of the fuel selector valve.NTSB ERA09CA097Accident · Serious injuriesData collectionFinal reportMiller Long EZ/XP · Wauchula, FLA total loss of engine power for undetermined reasons.NTSB CEN09CA092Accident · No injuriesData collectionFinal reportCessna 150 · Auxvasse, MOthe pilot's improper engine recovery procedures after a power-off stall which resulted in a loss of engine power. Contributing factors were the pilot's improper off-field landing procedures, and the lack of suitable terrain for the forced landing.NTSB WPR09LA050Accident · 1 fatalLimited investigationFinal reportBeech A36 · Coalinga, CAThe loss of engine power while in climb to cruise flight for undetermined reasons.NTSB WPR09LA047Accident · Serious injuriesLimited investigationFinal reportNickel RV-6 · Fresno, CAThe loss of engine power during initial climb for undetermined reasons.NTSB CEN09LA075Accident · Minor injuriesLimited investigationFinal reportHauser U/Hauser J KIT FOX CL · Boulder, COA loss of engine thrust due to the pilot's inadvertent activation of the propeller controls. Contributing to the accident were the non-standard propeller controls and the pilot's lack of experience in the airplane.NTSB CEN09WA073Accident · Minor injuriesForeign investigationBeech A100 · God's Lake Narrows, CanadaNone.NTSB CEN09CA080Accident · No injuriesData collectionFinal reportBeech E35 · Bloomington, INA partial loss of engine power due to a failure of the number one cylinder exhaust valve, and the associated secondary damage to the intake valve and piston.NTSB CEN09TA060Accident · 1 fatalFinal reportBell OH-58C · Quitman, ARThe pilot’s failure to execute a proper autorotation during a forced landing after a loss of rotor rpm for undetermined reasons.NTSB CEN09CA064Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Stafford, KSA loss of engine power for undetermined reasons.NTSB CEN09CA062Accident · No injuriesData collectionFinal reportPiper PA-18 · Foraker, OKThe pilot's failure to maintain directional control during the precautionary landing. Contributing to the accident were the wind gusts.NTSB ERA09CA054Accident · No injuriesData collectionFinal reportSnow 600 · Nashville, TNThe failure of the propeller shaft seal in flight. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB ERA09LA047Accident · Minor injuriesLimited investigationFinal reportBell 206B · Boynton Beach, FLA loss of engine power due to an undertorqued air line fitting to the fuel control.NTSB CEN09LA055Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Nacogdoches, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.