NTSB investigations
10,134 cases where the sequence of events included Collision with terr/obj (non-CFIT).
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\" = '470' 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" = '470' 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 ANC08LA061Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Soldotna, AKThe pilot's failure to remove the rudder gust lock prior to the flight.NTSB LAX08LA130Accident · Serious injuriesLimited investigationFinal reportGreco Drifter 912 · Homestead, FLThe pilot's failure to maintain adequate airspeed during a turn to the final approach leg of the traffic pattern, resulting in an accelerated stall.NTSB DEN08LA085Accident · Minor injuriesLimited investigationFinal reportNorth American SNJ-5 · Wolcott, COThe failure of the engine driven fuel pump flange due to oil starvation, resulting in the loss of engine power due to fuel starvation. Contributing to the accident was the lack of suitable terrain for a forced landing.NTSB DEN08CA089Accident · No injuriesData collectionFinal reportGrumman-Schweizer G-164C · De Witt, ARThe pilot's improper decision to attempt to close the canopy in flight, and his diverted attention resulting in the airplane impacting the terrain. Contributing to the accident was the excessively worn canopy latch.NTSB DEN08CA084Accident · Minor injuriesData collectionFinal reportPiper PA-25-235 · Mountain Grove, MOthe pilot's failure to maintain clearance with the power line.NTSB CHI08LA123Accident · 1 fatalLimited investigationFinal reportDickenson Bathtub · Broadhead, WIThe pilot's failure to maintain adequate airspeed during approach, which resulted in an aerodynamic stall.NTSB ANC08CA062Accident · No injuriesData collectionFinal reportCessna 185 · Talkeetna, AKThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was an inadvertent ground-loop.NTSB SEA08CA122Accident · Serious injuriesData collectionFinal reportSchempp-Hirth Nimbus-4M · Ephrata, WAThe pilot's inadequate preflight inspection and his failure to connect the left aileron control rod during assembly.NTSB MIA08LA101Accident · No injuriesLimited investigationFinal reportHigher Class Sport Hornet · Appling, GAThe interruption of fuel flow for undetermined reasons, resulting in a loss of engine power during flight.NTSB CHI08CA120Accident · No injuriesData collectionFinal reportCessna 177 · Bellefontaine, OHThe pilot's failure to maintain directional control during the aborted landing. Contributing to the accident was the fence.NTSB NYC08FA174Accident · 3 fatalField investigationFinal reportBeech A35 · Americus, GAThe pilot's failure to maintain control during the initial climb for undetermined reasons.NTSB LAX08CA129Accident · No injuriesData collectionFinal reportCessna A185F · Mexican Hat, UTThe pilot's failure to maintain directional control.NTSB DFW08CA127Accident · Minor injuriesData collectionFinal reportThompson Howard Pazmany PL-2 · Wagner, OKLoss of power for undetermined reasons.NTSB SEA08LA120Accident · 2 fatalLimited investigationFinal reportYakovlev Yak 52 · Vancouver, WAThe pilot's failure to maintain an airspeed sufficient to avoid a stall during a low altitude aerobatic maneuver. Contributing to the accident was the low altitude at which the pilot initiated the maneuver.NTSB LAX08LA128Accident · No injuriesLimited investigationFinal reportCessna 175A · Rio Linda, CAThe partial loss of engine power due to detonation. Contributing to the accident was trees in the landing area.NTSB DFW08CA149Accident · No injuriesData collectionFinal reportBellanca 14-13-3A · San Marcos, TXThe failure of the throttle cable clevis swage. Contributing to the accident was the uneven terrain available for landing.NTSB NYC08LA172Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Richmond Hill, GAThe loss of engine power during cruise flight due to fuel exhaustion, and the pilot's inadequate preflight inspection.NTSB DEN08LA082Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Houston, TXLoss of engine power for reasons undetermined. Contributing to the accident was a lack of suitable terrain for a forced landing.NTSB CHI08CA118Accident · No injuriesData collectionFinal reportLuscombe 8A · Remus, MIThe loss of engine power during approach due to fuel contamination. Contributing to the accident were the unsuitable terrain and a tree.NTSB NYC08CA170Accident · Minor injuriesData collectionFinal reportCessna 172F · White Plains, NYThe pilot's failure to maintain the proper glide path during the approach.NTSB DFW08LA121Accident · 1 fatalLimited investigationFinal reportTromsness Enterprises Turbine LE · Miami, OKThe pilot's failure to maintain control of the airplane for undetermined reasons. Contributing to the accident included his extensive use of medications and/or his multiple medical conditions and the failure of the FAA to follow up on his reported medication…NTSB DEN08CA086Accident · No injuriesData collectionFinal reportMooney M20E · Erie, COThe pilot failed to maintain directional control of the airplane during the touch and go landing.NTSB MIA08FA094Accident · 2 fatalField investigationFinal reportMooney M20M · Midlothian, VAThe pilot’s improper control inputs resulting from spatial disorientation.NTSB DFW08CA120Accident · No injuriesData collectionFinal reportHughes 269A · Lincoln, NEThe pilot's failure to properly execute a steep approach, which resulted in a tail strike and a loss of control.NTSB CHI08CA117Accident · No injuriesData collectionFinal reportCessna 182D · Madison, INThe inadequate preflight inspection of the landing gear tires by the pilot, which did not identify a worn tire and resulted in a flat tire during landing touchdown. An additional cause was the directional control not possible during the landing rollout, and…NTSB CHI08CA116Accident · Minor injuriesData collectionFinal reportMooney M20J · Howell, MIThe inadvertent stall and low airspeed while maneuvering back to the departure airport after the baggage door opened in flight. An additional cause was the plot's diverted attention to the opening of the baggage door.NTSB SEA08CA112Accident · No injuriesData collectionFinal reportCessna 185E · Bend, ORThe pilot's inadequate compensation for the crosswind condition and failure to maintain directional control. Contributing to the accident was an unexpected crosswind gust.NTSB LAX08CA123Accident · Minor injuriesData collectionFinal reportErvin SHA Glasair · Elk Creek, CAThe pilot's misjudged landing flare, inadequate bounced landing recovery technique, and failure to attain and maintain an adquate airspeed during an aborted landing. Contributing to the accident was the short runway.NTSB LAX08CA096Accident · No injuriesData collectionFinal reportCessna T210N · Coaldale, NVThe pilot's failure to maintain directional control after encountering an unknown object on the dirt runway.NTSB CHI08LA115Accident · No injuriesLimited investigationFinal reportCessna 182 · Romeo, MIThe misjudged landing flare by the pilot, and the inadequate landing gear inspection/repair procedure used by other maintenance personnel, resulting in the failure of the main landing gear strut during landing.NTSB NYC08LA167Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Ellijay, GAA loss of engine power for undetermined reasons.NTSB MIA08CA095Accident · No injuriesData collectionFinal reportChampion 7KCAB · Alexander City, ALThe separation of the right tail wheel spring on landing roll out for undetermined reasons, resulting in a loss of directional control and collision with a ditch.NTSB LAX08FA122Accident · 3 fatalField investigationFinal reportCarlton M. Cadwell Lancair IV-P · Mesa, AZThe pilot's failure to maintain an adequate airspeed during climb out resulting in an aerodynamic stall/spin.NTSB NYC08LA165Accident · 1 fatalLimited investigationFinal reportDragon Fly GT-500 · Paris, TNA fuel system configuration that was not in accordance with the engine manufacturer's published guidance, which resulted in a complete loss of engine power due to fuel starvation.NTSB DFW08CA104Accident · Serious injuriesData collectionFinal reportAir Tractor AT-602 · Paragould, ARThe pilot's failure to maintain clearance from electrical wires while maneuvering. Contributing to the accident were binding of the elevator control, inadvertent stall and trees.NTSB DFW08CA103Accident · No injuriesData collectionFinal reportBeech C-23 · De Queen, ARThe pilot's failure to maintain control of the airplane during an aborted landing. Contributing to the accident were the crosswind and the pilot's inadequate compensation for the wind conditions.NTSB CHI08CA112Accident · No injuriesData collectionFinal reportPierson RV-6 · Newark, ILThe partial loss of engine power due to the fracture of the number 4 exhaust valve, and the pilot's decision to shut-down the engine without sufficient altitude to ensure a safe glide path to the runway. Contributing to the accident was the barbed wire fence…NTSB MIA08CA093Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Ellington, CTThe pilot's failure to perform a go-around when the airplane floated during landing.NTSB LAX08CA119Accident · No injuriesData collectionFinal reportCarlson Quickie Q2 · Casper, WYA loss of directional control on landing due to the separation of the wing leveler trim knob and resulting reduced aileron control.NTSB DFW08LA106Accident · Serious injuriesLimited investigationFinal reportTomblingson-Leathers Breezy RLU-1 · Groveton, TXThe loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed during the forced landing. Contributing factors were the non-suitable terrain for the forced landing and the pilot's lack of experience in the airplane.NTSB DFW08LA105Accident · 1 fatalLimited investigationFinal reportBlevens Gary Vortex · Berclair, TXLoss of control for undetermined reasons.NTSB DFW08CA112Accident · Minor injuriesData collectionFinal reportHaecker Spacewalker · Kingsbury, TXThe loss of engine power for undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.NTSB DFW08CA102Accident · No injuriesData collectionFinal reportNorth American T-6G · Dallas, TXThe pilot's failure to maintain directional control while landing.NTSB DEN08FA078Accident · 2 fatalField investigationFinal reportCessna P206 · Mount Vernon, MOThe pilot's failure to maintain adequate airspeed, resulting in an inadvertent stall/spin. Contributing factors in this accident were the entanglement of the parachute in the elevator control system, reducing the pilot's ability to regain control.NTSB MIA08FA091Accident · 1 fatalField investigationFinal reportAeroFab Lake LA-250 · Skaneateles, NYThe certified flight instructor's failure to maintain airspeed during a steep turn.NTSB LAX08TA116Accident · No injuriesFinal reportHughes TH-55 · Logan, UTThe pilot's inadequate compensation for the wind conditions and failure to maintain control of the helicopter while hovering. Contributing to the accident were the wind gusts and the pilot's lack of recent experience in helicopters.NTSB LAX08FA115Accident · 2 fatalField investigationFinal reportCessna 150J · Sonora, CAThe pilot's failure to maintain airspeed while maneuvering, resulting in an aerodynamic stall and loss of aircraft control. Contributing to the accident were rising mountainous terrain and a high density altitude.NTSB LAX08CA120Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Plant City, FLThe pilot's excessive taxi speed, which led to a loss of control.NTSB DEN08LA081Accident · Minor injuriesLimited investigationFinal reportEnstrom F28C · Mosby, MOA loss of engine power for reasons undetermined, and the pilot's decision to discontinue the autorotation when he thought engine power had been restored. Contributing to the accident were the low altitude and excessive airspeed.NTSB CHI08IA113Incident · No injuriesIncident investigationFinal reportCessna 172P · Kelley's Island, OHThe pilot's failure to maintain aircraft control during landing. Contributing to the accident were the pilot's selection of the wrong runway and a tailwind.