NTSB investigations
3,371 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 ERA11CA373Accident · No injuriesData collectionFinal reportLeatherman Karl L Zodiac CH 601 HDS · Gray Court, SCThe total loss of engine power due to the failure of the radiator coolant supply fitting.NTSB CEN11LA449Accident · Minor injuriesLimited investigationFinal reportAbbey Victor RV9-A · Leander, TXThe partial loss of engine power for reasons that could not be determined because examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN11LA430Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Barron, WIThe loss of engine power, which resulted from fuel exhaustion due to the pilot's inadequate in-flight planning.NTSB CEN11LA429Accident · Minor injuriesLimited investigationFinal reportKeesler W8 Tailwind · Oshkosh, WIThe loss of engine power during initial climb for undetermined reasons.NTSB WPR11LA291Accident · Serious injuriesLimited investigationFinal reportRichard Challenger II · Moses Lake, WAA loss of engine power during the initial climb for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB ERA11LA370Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Holly Springs, MSThe pilot's incorrect positioning of the fuel tank selector before takeoff, which resulted in a loss of engine power due to fuel starvation during takeoff initial climb.NTSB WPR11LA290Accident · Minor injuriesLimited investigationFinal reportChristen Industries Pitts S-1T · Alkali Lake, ORThe loss of engine oil during cruise flight due to the failure of the front bearing oil seal.NTSB WPR11LA289Accident · Serious injuriesLimited investigationFinal reportLemond FLY Fisher · West Glacier, MTA total loss of engine power during takeoff due to water contamination in the fuel system. Contributing to the accident was the pilot’s inadequate preflight inspection of the airplane.NTSB WPR11LA288Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Lewistown, MTThe fatigue fracture and separation of the fuel bypass line, which resulted in a total loss of engine power.NTSB ERA11CA364Accident · Minor injuriesData collectionFinal reportHelio H-295 · Brasstown, NCThe pilot's inadequate preflight planning, which resulted in a loss of engine power due to fuel exhaustion.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 WPR11CA286Accident · No injuriesData collectionFinal reportAir Tractor AT301 · Circle, MTThe pilot's failure to attain and maintain an adequate airspeed during initial climb.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 ERA11LA359Accident · Serious injuriesLimited investigationFinal reportNavion Navion B · Red Oak, NCThe pilot's inadvertent movement of the fuel tank selector handle to the off position, resulting in a total loss of engine power due to fuel starvation.NTSB ERA11CA352Accident · No injuriesData collectionFinal reportPiper PA18-160 · Ridgeville, SCA total loss of engine power due to fuel exhaustion as a result of the pilot's inadequate fuel planning.NTSB CEN11WA412Accident · Serious injuriesForeign investigationMcDonnell Douglas Helicopter 369E · Glastonbury, United KingdomOn June 19, 2011, at 1420 universal coordinated time (UTC), a McDonnell Douglas Helicopter Company model 369E, United Kingdom registration G-KSWI, s/n 0204E, was substantially damaged during an emergency landing after experiencing a mechanical failure of the…NTSB WPR11LA266Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Mount Pleasant, UTThe pilot’s failure to determine the airplane’s fuel quantity before takeoff, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN11LA413Accident · No injuriesLimited investigationFinal reportCessna 172N · Bedford Park, ILA loss of engine power due to a fractured push rod precipitated by a stuck exhaust valve.NTSB CEN11LA402Accident · Serious injuriesLimited investigationFinal reportCessna P210R · Albia, IAThe pilot's inadequate preflight inspection, in which he did not detect that less fuel was on board the airplane than planned, which precipitated a loss of engine power due to fuel exhaustion during initial descent.NTSB WPR11CA261Accident · Minor injuriesData collectionFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Pullman, WAThe pilot's failure to maintain clearance from power lines while maneuvering.NTSB WPR11CA296Accident · Minor injuriesData collectionFinal reportCessna 188 · Glasgow, MTThe pilot's improper fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN11LA385Accident · No injuriesLimited investigationFinal reportWiley C W RV-6A · Colgate, OKThe loss of engine power for undetermined reasons.NTSB CEN11FA383Accident · Minor injuriesField investigationFinal reportBoeing B-17G · Oswego, ILAn inadequate repair of the fuel tank that allowed the fuel leak to continue, ultimately resulting in an in-flight fire.NTSB CEN11LA384Accident · Serious injuriesLimited investigationFinal reportFisher Lancair · Azle, TXThe pilot’s inadequate in-flight fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB ERA11FA334Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Westbrook, CTA total loss of engine power during approach due to inadequate torque on the No. 3 cylinder hold-down nuts.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 CEN11LA381Accident · Minor injuriesLimited investigationFinal reportBellanca 17-30A · Canton, TXThe loss of fuel pressure for undetermined reasons, which resulted in a loss of engine power.NTSB CEN11CA410Accident · No injuriesData collectionFinal reportTaft, Malcolm J SR Glastar · Canon City, COA loss of engine power due to an overheated engine as a result of a malfunction of the modified engine cooling system, necessitating a forced landing on unsuitable terrain.NTSB WPR11LA246Accident · No injuriesLimited investigationFinal reportScottish Series 100 MDL 101 · Chandler, AZA loss of engine power during cruise flight for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB ERA11LA325Accident · Minor injuriesLimited investigationFinal reportClamar Floats CA-4 · Merritt Island, FLThe loss of engine power during takeoff for reasons that could not be determined because a postaccident examination could not be performed before the airplane was disassembled.NTSB WPR11LA253Accident · No injuriesLimited investigationFinal reportCessna A188B · Pine Bluffs, WYA partial loss of engine power during takeoff for reasons that could not be determined because postaccident examination did not reveal any mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR11LA244Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Stockton, CAThe pilot's failure to maintain clearance from obstacles.NTSB ERA11IA320Incident · No injuriesIncident investigationFinal reportRobinson Helicopter R22 Mariner · Redding, CTThe pilot's inadequate helicopter preflight inspection and the mechanic’s inadequate annual inspection, both of which failed to detect a worn bolt in the tail rotor teeter hinge prior to its fracture due to fatigue.NTSB CEN11FA358Accident · 2 fatalField investigationFinal reportRockwell 112 · Bryan, TXThe pilot's inadequate fuel planning, which resulted in a loss of engine power due to fuel exhaustion, and his improper control inputs following the loss of engine power, which resulted in an aerodynamic stall and subsequent loss of control. Contributing to…NTSB WPR11LA238Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Hazelton, IDA total loss of engine power during low-level maneuvering due to an excessively worn carburetor.NTSB CEN11LA356Accident · Minor injuriesLimited investigationFinal reportBell 206 · Walton, KSA loss of engine power for undetermined reasons because postaccident examination of the airframe and engine revealed no anomalies.NTSB CEN11LA348Accident · Minor injuriesLimited investigationFinal reportPiper J3C · Cypress, TXThe loss of engine power due to carburetor ice.NTSB CEN11LA350Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-160 · Frederick, OKAn in-flight fire for undetermined reasons.NTSB ANC11CA033Accident · Minor injuriesData collectionFinal reportPiper PA-12 · Wasilla, AKThe pilot's inadequate preflight inspection, resulting in a departure with the fuel selector in the "off" position, a subsequent loss of engine power, and an off-airport emergency landing.NTSB CEN11LA339Accident · No injuriesLimited investigationFinal reportMD Helicopter 369E · Victoria, TXThe pilot’s failure to ensure that the governor limit switch was properly set, which resulted in reduced engine power.NTSB ERA11LA301Accident · No injuriesLimited investigationFinal reportLeigh S-6 Coyote II · New Kent, VAA total loss of engine power for undetermined reasons.NTSB WPR11LA220Accident · No injuriesLimited investigationFinal reportMD Helicopter 369D · Columbia, CAThe loss of power transmission to the main rotor for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation of the helicopter.NTSB ERA11LA298Accident · No injuriesLimited investigationFinal reportThrush S2R-T660 · Greenwood, MSA partial loss of engine power during low-altitude maneuvering for undetermined reasons.NTSB ERA11FA295Accident · Serious injuriesField investigationFinal reportBeech G33 · Washington, PAA total loss of engine power due to fuel starvation, as a result of the pilot's improper fuel management and preflight inspection. Contributing to the accident was the pilot's failure to comply with the manufacturer's published takeoff and emergency…NTSB CEN11CA353Accident · No injuriesData collectionFinal reportHawker Beechcraft G36 · Guymon, OKThe pilot's loss of directional control while landing in gusty, crosswind conditions.NTSB ERA11LA292Accident · No injuriesLimited investigationFinal reportFlight Design Ctls · Troy, SCThe pilots’ failure to ensure that the airplane had enough fuel to complete the planned flight, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN11LA327Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Chico, TXThe mechanic's improper installation of the turbocharger's exhaust balance system, which resulted in an in-flight fire.NTSB ERA11CA288Accident · Minor injuriesData collectionFinal reportSchleicher ASW-27 · Athens, TNThe pilot's inadequate visual lookout resulting in a collision with power lines while making an off-airport landing.NTSB ERA11FA285Accident · 2 fatalField investigationFinal reportHebert Peter J Lancair Legacy · Richlands, NCThe pilot's improper in-flight fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB CEN11CA322Accident · No injuriesData collectionFinal reportCessna 172K · Farmersville, TXA loss of engine power due to fuel starvation as a result of the pilot's improper fuel management.