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 ERA12LA425Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lakewood, NJThe loss of engine power during climb for reasons that could not be determined during postaccident examination of the engine and engine systems or during postaccident operational testing of the engine.NTSB ERA12CA454Accident · Minor injuriesData collectionFinal reportLet L-23 Super Blanik · Benton, TNThe pilot's inadvertent extension of the wing airbrakes, which resulted in a loss of lift and subsequent landing prior to the runway.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 ERA12LA417Accident · No injuriesLimited investigationFinal reportLuters Arnis V Legend · Glenwood, FLThe total loss of engine power due to the airplane builder’s improper installation of the fuel control unit condition lever cables, which resulted in the airplane’s subsequent forced landing.NTSB ANC12LA058Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Gustavus, AKThe fatigue failure of the engine crankshaft for reasons that could not be determined during postaccident metallurgical examination.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 CEN12CA415Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Richmond, INThe pilot’s failure to ensure that the fuel selector was properly positioned, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN12LA389Accident · No injuriesLimited investigationFinal reportHoyle Fighter Escort Wings · Pueblo, COAn internal failure of one of the electrical system’s two batteries combined with the inadequate electrical system design, which resulted in a total loss of engine power.NTSB CEN12LA388Accident · No injuriesLimited investigationFinal reportCessna A150K · Mamou, LAThe pilot's inadequate preflight inspection, which resulted in a partial loss of engine power due to fuel contamination.NTSB WPR12LA309Accident · No injuriesLimited investigationFinal reportBeech A36 · Rock Springs, WYThe total loss of engine power due to fuel starvation because of the incorrectly installed fuel cap. Contributing to the accident was the pilot’s decision to continue the flight using fuel from the left fuel tank after she observed fuel streaming from the…NTSB ERA12LA410Accident · No injuriesLimited investigationFinal reportPiper J5A · Atlantic Ocean (Atlantic Ocean)A loss of engine power for reasons that could not be determined because the aircraft sank after ditching and was not recovered.NTSB ANC12CA059Accident · No injuriesData collectionFinal reportDosser Dale A Blade 582 · Two Rivers, AKThe total loss of engine power during cruise flight due to fouled spark plugs, which resulted from a stuck mixture control.NTSB ERA12LA405Accident · No injuriesLimited investigationFinal reportCessna 152 · Miami, FLThe pilots’ operation of the airplane with an insufficient supply of engine oil, resulting in engine seizure and total loss of engine power.NTSB ERA12LA400Accident · No injuriesLimited investigationFinal reportBarney Oldfield Baby Lakes · Anderson, SCA total loss of engine power as a result of an inadequate amount of lubricating oil in the engine. Contributing to the accident was the pilot's improper preflight inspection.NTSB ERA12LA397Accident · Minor injuriesLimited investigationFinal reportCessna 170 · Biddeford, MEA total loss of engine power due to water contamination of the fuel. Contributing to the accident was the pilot/owner’s inadequate preflight inspection.NTSB ERA12LA394Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Ocilla, GAA failure of the No. 2 cylinder connecting rod due to a lack of lubrication, which resulted in a total loss of engine power.NTSB WPR12LA256Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · Riverton, WYAn engine overspeed shortly after takeoff for reasons that could not be determined because postaccident examination revealed no mechanical malfunctions or failures that would have precluded normal operation.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 CEN12LA352Accident · No injuriesLimited investigationFinal reportGrumman G164 · Higginson, ARThe partial loss of engine power for reasons that could not be determined due to impact and fire damage.NTSB ERA12LA379Accident · Minor injuriesLimited investigationFinal reportBell 427 · Indiantown, FLThe inflight collision with birds, resulting in damage to the rotor head assembly and a subsequent forced landing and rollover.NTSB ANC12CA050Accident · No injuriesData collectionFinal reportWalls Craig C Snowyriver Special · Chugiak, AKThe pilot’s improper fuel planning, which resulted in fuel exhaustion and a total loss of engine power during descent.NTSB ERA12LA380Accident · Minor injuriesLimited investigationFinal reportPittman Eddie G CGS Hawk Arrow II · Monroe, VAThe pilot’s improper preflight planning and inflight fuel management, which resulted in the total loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s unfamiliarity with the airplane’s systems.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 ERA12LA366Accident · No injuriesLimited investigationFinal reportBell 206B · Longboat Key, FLUnknown personnel's failure to comply with the engine manufacturer's engine fuel pump replacement guidance, which resulted in a total loss of engine power due to the engine fuel pump failure.NTSB ERA12LA368Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Piney Flats, TNThe mechanic’s improper maintenance of the main transmission aft pinion nut and belt drive system, which resulted in the uncoupling of the tail rotor driveshaft and the subsequent loss of helicopter control.NTSB CEN12LA357Accident · No injuriesLimited investigationFinal reportRockwell International S-2R · Howard, SDA fractured fabricated aluminum oil line, which resulted in oil exhaustion followed by a forced landing.NTSB CEN12CA313Accident · Serious injuriesData collectionFinal reportAyres S2R-R1340 · Clear Lake, SDThe pilot's failure to perform a detailed observation of the power lines before beginning the aerial application work, which resulted in an inadvertent collision with the two lower wires.NTSB ERA12LA346Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 · Destin, FLThe partial loss of engine power due to a stuck (open) exhaust valve in the No. 5 cylinder. Contributing to the accident was the operator’s failure to follow the engine manufacturer’s directives concerning cooling of the engine after flight.NTSB ERA12CA348Accident · Minor injuriesData collectionFinal reportMooney M20C · Pembroke Pines, FLThe pilot's improper fuel management, which resulted in a total loss of engine power during approach due to fuel exhaustion.NTSB CEN12LA309Accident · Minor injuriesLimited investigationFinal reportQuicksilver Sprint II · Lebanon, ILThe total loss of engine power due to a fatigue failure of the crankshaft, attributed to the relative movement between the crankshaft and flywheel assembly.NTSB ERA12LA343Accident · No injuriesLimited investigationFinal reportCessna 195A · Tipton, PAA fatigue failure of a copper oil line, which resulted in a partial loss of engine power due to oil starvation.NTSB WPR12CA213Accident · No injuriesData collectionFinal reportRotherwick HR Glasair III · Darby, MTThe pilot’s loss of directional control during an emergency landing on a paved highway.NTSB CEN12LA306Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Marion, ARThe 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 WPR12CA206Accident · No injuriesData collectionFinal reportHunter A-20 Vista Cruiser · Molalla, ORThe pilot's failure to maintain clearance from a rock during an off-airport landing.NTSB ERA12LA332Accident · Serious injuriesLimited investigationFinal reportStinson SR-7B · West Ossipee, NHThe pilot's inadequate application of carburetor heat which resulted in the formation of carburetor ice and a partial loss of engine power.NTSB CEN12LA296Accident · Minor injuriesLimited investigationFinal reportMaule M-7-420AC · Hanover Township, MIA total loss of engine power for reasons that could not be determined during an exhaustive postaccident examination of the engine and its components.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 WPR12LA200Accident · No injuriesLimited investigationFinal reportChampion 7GC · Rexburg, IDA decrease in indicated oil pressure while maneuvering at low altitude for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Also causal was the pilot’s failure to…NTSB CEN12LA289Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Grants, NMThe loss of engine power due to an excessively rich fuel mixture that occurred during operations at idle power settings at a high density altitude. Contributing to the accident was the flight instructor’s poor decision-making in choosing to practice an…NTSB WPR12LA198Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Hanksville, UTThe pilot’s failure to maintain adequate airspeed while maneuvering at a low altitude in high density altitude conditions, which resulted in the airplane’s inability to climb or maintain clearance from terrain.NTSB ERA12LA340Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Williston, FLLoss of engine power for reasons that could not be determined during postaccident examination and testing, which included a successful postaccident engine run.NTSB ERA12WA504Accident · Minor injuriesForeign investigationPiper PA-28-235 · Tartu, EstoniaOn May 4, 2012, about 2055 universal coordinated time, a Piper PA-28-235, Latvian registration YL-MED, was substantially damaged when it impacted a ditch, during a forced landing at night after a loss of power near Tartu Ulenurme Airport (EETU), Tartu,…NTSB WPR12LA195Accident · Serious injuriesLimited investigationFinal reportRobinson R22 · Kailua-Kona, HIA loss of engine power while maneuvering for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN12CA274Accident · No injuriesData collectionFinal reportAir Tractor AT-301 · Cedar Bluffs, NEThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.NTSB WPR12LA190Accident · Serious injuriesLimited investigationFinal reportCessna T210 · Elberta, UTA loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.NTSB ERA12LA312Accident · Minor injuriesLimited investigationFinal reportShoup Ronald R RV-6A · Milton, FLA loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.NTSB ERA12LA318Accident · Minor injuriesLimited investigationFinal reportTemco GC-1B · Dayton, TNA partial loss of engine power during low-altitude maneuvers for reasons that could not be determined because the engine examination did not reveal any mechanical malfunctions or failures that would have precluded normal operation; however the carburetor was…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 ERA12LA306Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Fowler's Bluff, FLThe pilot's inadequate in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.