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 ERA15LA151Accident · No injuriesLimited investigationFinal reportPiper PA23 · San Juan, PRThe total loss of right engine power 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.NTSB ERA15LA149Accident · 1 fatalLimited investigationFinal reportPiper PA-24-250 · Fort Myers, FLThe pilot's inadvertent placement of both fuel selectors to the "off" position, which resulted in fuel starvation and a total loss of engine power.NTSB WPR15LA127Accident · Minor injuriesLimited investigationFinal reportJimenez Vans RV 7A · Dayton, NVA loss of engine power during descent for reasons that could not be determined because postaccident examination of the engine revealed no anomalies that would have precluded normal operation.NTSB WPR15LA126Accident · No injuriesLimited investigationFinal reportPiper PA 18-150 · Merced, CAThe separation of the flight control stick from the stub due to its improper installation.NTSB CEN15LA177Accident · No injuriesLimited investigationFinal reportErcoupe 415 C · St Jacob, ILThe loss of engine power during the go-around due to fuel contamination.NTSB WPR15FA121Accident · Serious injuriesField investigationFinal reportRyan Aeronautical ST3KR · Santa Monica, CAA total loss of engine power during initial climb when the carburetor main metering jet became unseated, which led to an extremely rich fuel-to-air ratio. Contributing to the accident was the lack of adequate carburetor maintenance instructions. Contributing…NTSB ERA15LA145Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Venice, FLA total loss of engine power for reasons that could not be determined because postaccident testing of the engine revealed no anomalies.NTSB ERA15FA139Accident · 1 fatalField investigationFinal reportAdams Donald L DA1 · Sebring, FLA partial loss of engine power for reasons that could not be determined based on the available evidence.NTSB ERA15LA142Accident · No injuriesLimited investigationFinal reportPiper PA28 · Jacksonville, FLThe total loss of engine power due to carburetor ice.NTSB WPR15LA103Accident · Serious injuriesLimited investigationFinal reportCessna 150M · Layton, UTThe total loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate preflight and in-flight fuel planning, which did not account for the increased headwind.NTSB CEN15LA146Accident · Minor injuriesLimited investigationFinal reportPiper PA 28R-180 · Haviland, KSThe loss of torque on the No. 4 cylinder through bolts, which led to the subsequent failure of the piston, the liberation of the connecting rod, the separation of the No. 4 cylinder from the crankcase in cruise flight, and the airplane’s subsequent impact…NTSB WPR15LA101Accident · Minor injuriesLimited investigationFinal reportVans RV7 - Undesignat · Belfair, WAA total loss of engine power during cruise flight due to the fatigue failure of the engine crankshaft. Contributing to the accident was the unapproved repair and improper inspection of the engine crankshaft.NTSB ERA15CA120Accident · Minor injuriesData collectionFinal reportPiper PA 18-150 · Brookneal, VAThe flight instructor and pilot-rated student's inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR15LA096Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Calexico, CAA partial loss of engine power 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.NTSB CEN15LA132Accident · No injuriesLimited investigationFinal reportButler Raymond Rotorway Exec 162F · Seadrift, TXA fault in the No. 1 engine control module, which disabled the ignition system and resulted in the engine losing power; during the subsequent autorotation, the main rotor rpm was further reduced just before touchdown, which resulted in a hard landing.NTSB CEN15CA125Accident · Minor injuriesData collectionFinal reportCessna 182C · Fort Morgan, COThe pilot's improper fuel planning/management, which resulted in the total loss of engine power due to fuel exhaustion and the subsequent forced landing in a pasture.NTSB WPR15LA090Accident · Minor injuriesLimited investigationFinal reportCessna 150E · Silver Springs, NVThe loss of engine power for reasons that could not be determined during a postaccident examination of the airplane.NTSB CEN15LA112Accident · No injuriesLimited investigationFinal reportMooney M20C · Lonoke county, ARThe loss of engine power due to fuel starvation.NTSB WPR15LA085Accident · No injuriesLimited investigationFinal reportCubcrafters CC11-160 · San Luis Obispo, CAThe pilot's inadequate instrument scan during cruise flight, which resulted in his failure to notice a loss of engine oil pressure. Contributing to the accident was the failure of the oil pressure transducer supply line, which resulted in oil exhaustion and a…NTSB WPR15FA081Accident · 1 fatalField investigationFinal reportGibbs Lancair 320 · Van Nuys, CAThe pilot's improper decision to take off despite low fuel alerts, which resulted in a total loss of engine power due to fuel exhaustion, his subsequent failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack, which…NTSB ERA15LA094Accident · No injuriesLimited investigationFinal reportCessna 172 · Norfolk, VAThe engine’s failure to regain full power after a simulated engine failure for reasons that could not be determined during postaccident examinations and testing.NTSB ERA15LA092Accident · Serious injuriesLimited investigationFinal reportBeech V35B · Long View, NCThe improper installation of the lower rear crankshaft counterweight snap rings by unknown maintenance personnel, which resulted in the separation of the counterweight and a subsequent total loss of engine power during initial climb.NTSB ERA15LA090Accident · Minor injuriesLimited investigationFinal reportCessna P206 · Key West, FLA total loss of engine power for reasons that could not be determined during postaccident examinations and testing.NTSB ERA15FA088Accident · 4 fatalField investigationFinal reportPiper PA34 · Kuttawa, KYThe pilot's failure to properly set the left engine fuel selector before takeoff and to recognize the incorrect setting during the flight, which resulted in fuel starvation and a loss of engine power on both engines.NTSB WPR15TA071Accident · Serious injuriesFinal reportMD Helicopter 369FF · Las Vegas, NVA total 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 WPR15IA080Incident · No injuriesIncident investigationFinal reportRobinson Helicopter R22 Beta II · Phoenix, AZThe failure of the fanshaft due to fatigue.NTSB ERA15LA077Accident · No injuriesLimited investigationFinal reportThomas R Wade Revelation · Ellisville, MSThe failure of the uncertified engine's front connecting rod needle bearing, which resulted in damage to the front piston and a subsequent loss of engine power. Contributing to the accident was the pilot’s decision to operate the airplane with the uncertified…NTSB CEN15LA077Accident · Serious injuriesLimited investigationFinal reportNew Piper PA 32R-301T · Springfield, MOThe pilot’s decision to descend below the recommended altitude during approach for landing in night visual meteorological conditions, and his failure to see and avoid a lighted tower, which resulted in collision with the tower and a subsequent total loss of…NTSB WPR15LA055Accident · No injuriesLimited investigationFinal reportFouga CM 170R Magister · Lake Havasu City, AZA total loss of engine power to both engines during descent due to fuel starvation as a result of an interruption of the fuel flow, which resulted in a forced landing to a short strip and a subsequent overrun.NTSB ERA15LA072Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Brookline, NHThe student pilot’s failure to maintain clearance from a wire during an off-airport landing following a partial loss of engine power for reasons that could not be determined during postaccident examination.NTSB ERA15LA071Accident · Minor injuriesLimited investigationFinal reportCessna 210 5(205) · Sussex, NJMaintenance personnel’s inadequate inspection of the No. 2 cylinder valve area during the most recent annual inspection, which resulted in the in-flight failure of the intake valve springs due to rust on the spring surfaces and subsequent fatigue cracking.NTSB CEN15CA067Accident · No injuriesData collectionFinal reportCessna 210 · Edinburg, TXThe loss of engine power due to fuel exhaustion, which resulted from the non-certificated pilot's inadequate preflight planning and inflight decision making.NTSB CEN15LA063Accident · Serious injuriesLimited investigationFinal reportSiegel Gerald Long EZ · McGregor, TXA loss of engine power during takeoff due to excessive debris in the fuel system.NTSB ERA15LA063Accident · No injuriesLimited investigationFinal reportCessna 182 · Hartford, CTThe partial loss of engine power during climb after takeoff for a reasons that could not be determined because postaccident engine examination revealed no evidence of mechanical malfunctions or failures.NTSB ERA15LA053Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Clinton, CTThe pilot's inadequate fuel planning and improper fuel management, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot's failure to follow proper procedures in response to the loss of engine power.NTSB CEN15IA046Incident · No injuriesIncident investigationFinal reportBell 407 · Viosca Knoll 989Engine power surges during takeoff for reasons that could not be determined during postaccident testing of the engine and the engine control unit.NTSB ERA15FA049Accident · Serious injuriesField investigationFinal reportMooney M20C · Lewisburg, WVThe pilot's failure to maintain airspeed while maneuvering, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident were abnormal engine operation due to improper…NTSB ERA15CA048Accident · No injuriesData collectionFinal reportCessna 177 · Landrum, SCThe pilot's improper preflight planning, which resulted in a loss of engine power due to fuel exhaustion.NTSB CEN15FA032Accident · 1 fatalField investigationFinal reportLangston, Frederick L RV 4 · Boerne, TXA total loss of engine power for reasons that could not be determined, because post accident examination did not reveal any mechanical malfunctions or anomalies that would have precluded normal operation.NTSB CEN15LA028Accident · 1 fatalLimited investigationFinal reportHuebbe Sonex HB · Plainview, ILThe loss of engine power during cruise flight due to a fatigue fracture of the crankshaft, which resulted in a forced landing on unsuitable terrain.NTSB CEN15CA033Accident · No injuriesData collectionFinal reportPiper PA-23-250 · Quincy, ILThe pilot's improper fuel management, which resulted in the total loss of power to both engines due to fuel exhaustion and the subsequent forced landing in a field. Also causal to the accident was the pilot's decision to use the slower emergency hand-pump to…NTSB ERA15LA029Accident · Minor injuriesLimited investigationFinal reportPiper PA 22-150 · Tompkins, NYA total loss of engine power for reasons that could not be determined during postaccident examinations and testing.NTSB CEN15LA038Accident · Minor injuriesLimited investigationFinal reportStol UC 1 · Jacksonville, TXThe loss of right engine power while climbing due to fuel starvation for reasons that could not be determined during postaccident airplane examination and testing, which led to a forced landing on hilly terrain.NTSB WPR15LA020Accident · Serious injuriesLimited investigationFinal reportWinston W Walker Thunder Mustang · Globe, AZThe separation of the main crank drive pulley from the engine’s accessory section due to three of its securing bolts backing out of their holes, which subsequently resulted in two accessory belts becoming unsecure, both crank sensor plugs becoming dislodged,…NTSB ERA15LA030Accident · No injuriesLimited investigationFinal reportNorth American T 6G · Naples, FLThe total loss of engine power during the initial climb due to fuel starvation for reasons that could not be determined because postaccident examinations of the airframe and engine fuel system components revealed no evidence of a mechanical malfunction or…NTSB CEN15TA035Accident · No injuriesFinal reportBell UH1H · San Isidro, TXThe flight crew's failure to ensure that the sliding cabin door was properly secured before the flight.NTSB ERA15IA024Incident · No injuriesIncident investigationFinal reportCirrus Design SR22 · Lexington, NCMaintenance personnel's improper tightening of the crankcase through bolt nuts during reassembly of the engine at the last overhaul, which resulted in the failure of the crankshaft and the subsequent total loss of engine power.NTSB WPR15LA015Accident · Minor injuriesLimited investigationFinal reportPiper PA28 151 · Bullhead City, AZA partial loss of engine power during the initial climb 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.NTSB ERA15LA014Accident · Minor injuriesLimited investigationFinal reportCessna 180K · Boca Raton, FLMaintenance personnel’s failure to apply proper torque to the cylinder flange nuts and through bolts, which resulted in shifting of the Nos. 1 and 2 main bearings, loss of lubrication, failure of the crankshaft, and a subsequent total loss of engine power.NTSB WPR15LA008Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-180 · Bend, ORA partial loss of engine power due to carburetor icing, which resulted from the pilot’s failure to apply carburetor heat after takeoff and during the climb.