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 CEN11FA479Accident · 2 fatalField investigationFinal reportCessna 150L · Silverton, COThe pilot's failure to maintain control of the airplane while operating it at low levels above mountainous terrain and in excess of its maximum allowable gross weight, which resulted in an aerodynamic stall. The pilot's failure to maintain control resulted…NTSB CEN11CA477Accident · No injuriesData collectionFinal reportPiper PA-25-235 · Minot, NDThe pilot's inadequate inspection of the takeoff area which resulted in a collision with terrain and the subsequent loss of control during takeoff.NTSB CEN11LA490Accident · No injuriesLimited investigationFinal reportDarrow Stephen AL-6 · Peyton, COThe loss of engine power during the descent for reasons that could not be determined because a thorough examination of the engine could not be completed due to the remote accident site.NTSB ANC11CA064Accident · No injuriesData collectionFinal reportPiper PA-18A 150 · Cordova, AKThe pilot's failure to maintain sufficient airspeed during approach, resulting in an aerodynamic stall, and collision with terrain.NTSB WPR11LA325Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Wenatchee, WAThe pilot's failure to maintain control while hovering out of ground effect at low altitude, which resulted in the helicopter settling into trees.NTSB ERA11LA397Accident · No injuriesLimited investigationFinal reportGates Lear Jet 35 · Opa-Locka, FLThe flightcrew’s inadvertent encounter with windshear during landing, which resulted in a loss of control.NTSB WPR11CA326Accident · Minor injuriesData collectionFinal reportMaule M-7-235C · Tonasket, WAThe pilot's failure to achieve the proper touchdown point, which resulted in a landing overrun.NTSB WPR11CA322Accident · Minor injuriesData collectionFinal reportDova Aircraft Sro DV-1 Skylark · Placerville, CAThe pilot's failure to maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall.NTSB WPR11CA321Accident · Minor injuriesData collectionFinal reportLeineke Walter L Thorp T-211 · Cedar City, UTThe pilot's misjudgment of the fuel consumption, which lead to fuel exhaustion. Contributing to the accident was the pilot's lack of experience in the accident airplane.NTSB ERA11LA393Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Ormond Beach, FLThe loss of engine power due to fuel starvation, which resulted from the flight instructor's inadequate in-flight fuel management.NTSB CEN11CA470Accident · No injuriesData collectionFinal reportRans S7 · Cubero, NMThe pilot's failure to attain rotation speed prior to takeoff.NTSB ERA11FA391Accident · 7 fatalField investigationFinal reportCessna 421C · Demopolis, ALThe pilot's failure to maintain airplane control during a single-engine approach and his failure to fly an appropriate traffic pattern for a single-engine landing. Contributing to the accident was a total loss of engine power on the right engine due to a…NTSB CEN11FA469Accident · 1 fatalField investigationFinal reportBowie Richard Sonerai II · Dudley, MOFuel starvation due to the pilot’s improper fuel management and his decision to conduct the flight while under the influence of marijuana.NTSB CEN11FA468Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Rising Sun, INThe noninstrument-rated pilot's decision to continue the visual flight rules flight into instrument meteorological conditions, which resulted in his spatial disorientation and failure to maintain clearance from terrain.NTSB CEN11FA467Accident · 1 fatalField investigationFinal reportRans S-12 · Scott, ARThe pilot’s loss of airplane control, likely due to a cardiac event.NTSB WPR11LA317Accident · 1 fatalLimited investigationFinal reportSchweizer SGS 2-32 · Bigfork, MTThe pilot’s failure to maintain adequate airspeed and his excessive control inputs during a simulated rope break while taking off, which resulted in an accelerated aerodynamic stall.NTSB CEN11LA464Accident · Serious injuriesLimited investigationFinal reportBurtner Charles W Derjager D IX · East Liverpool, OHThe pilot's improper landing flare, which resulted in a porpoised landing and propeller contact with the runway, which caused an in-flight disintegration of the propeller during the go-around, and subsequent collision with trees.NTSB ANC11LA060Accident · Serious injuriesLimited investigationFinal reportSonex / John D. McCarter Waiex · Sterling, AKThe pilot's failure to maintain sufficient airspeed to avoid an aerodynamic stall following a loss of engine power for undetermined reasons.NTSB WPR11LA311Accident · Minor injuriesLimited investigationFinal reportCessna R182 · Hesperia, CAThe separation of the end baffle cone inside the muffler, which blocked airflow through the engine after takeoff and resulted in a loss of engine power and an off-airport landing into obstacles.NTSB ERA11CA384Accident · No injuriesData collectionFinal reportAeronca 7DC · Greenland, NHThe pilot's improper flare, which resulted in a bounced landing, and subsequent loss of control during an attempted go-around maneuver.NTSB CEN11LA460Accident · No injuriesLimited investigationFinal reportAyres S2R600 · Pine Bluff, ARThe use of an incorrect mounting bolt by maintenance persons to attach the engine torque sensor, which resulted in an internal failure of the torque sensor and subsequent loss of engine power due to fuel starvation.NTSB ANC11CA058Accident · Serious injuriesData collectionFinal reportAviat A-1B · Palmer, AKThe pilot's decision to fly at a low altitude in mountainous terrain and weather conditions conducive to downdrafts.NTSB WPR11LA305Accident · Minor injuriesLimited investigationFinal reportCessna U206 · Nogales, AZThe pilot did not maintain airplane control during the initial climb.NTSB ERA11LA379Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Egremont, MAA partial loss of engine power due to the No. 4 intake and exhaust valves becoming lodged in the valve guides, which resulted from a lack of use, improper engine storage preparation, and improper return to service from indefinite storage.NTSB ANC11IA059Incident · No injuriesIncident investigationFinal reportHughes 500D · McGrath, AKA fatigue fracture of the governor-to-fuel control Pc line, which resulted in a partial loss of engine power.NTSB WPR11LA324Accident · Serious injuriesLimited investigationFinal reportM Squared Sprint 1000 · Heise, IDThe pilot's failure to maintain adequate airspeed while maneuvering, which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of experience in the accident airplane make and model.NTSB WPR11FA304Accident · 2 fatalField investigationFinal reportCessna 180D · Santa Paula, CAThe pilot’s failure to maintain clearance from a telephone line while flying at a low altitude in dusk lighting conditions.NTSB ERA11LA400Accident · No injuriesLimited investigationFinal reportFessenden Alfred Expermental RV-4 · Fort Drum, FLA total loss of engine power for undetermined reasons.NTSB ERA11LA383Accident · No injuriesLimited investigationFinal reportCessna 150L · Plymouth, MAA partial loss of engine power during initial climb due to a stuck cylinder valve, which resulted from excessive corrosion and carbon deposits on the valve springs due to inadequate maintenance.NTSB ERA11CA378Accident · Minor injuriesData collectionFinal reportBeech 77 · Jonesville, VAThe pilot's delayed decision to abort the takeoff.NTSB CEN11CA445Accident · Minor injuriesData collectionFinal reportSkytrails Lsa Predator · Coldspring, TXThe pilot's inadequate consideration of obstructions on his flight path and inability to maintain altitude following an unexplained loss of lift.NTSB WPR11LA303Accident · Serious injuriesLimited investigationFinal reportArrow Falcon Exporters OH-58C · Brentwood, CAThe failure of the main rotor mast due to fatigue cracking originating from corrosion pits.NTSB CEN11FA444Accident · 1 fatalField investigationFinal reportBoeing B75N1 · Wetmore, COThe pilot's failure to maintain clearance from terrain while maneuvering at low altitude.NTSB CEN11FA443Accident · 2 fatalField investigationFinal reportKoen Lancair Laser IV-P · Port O'Connor, TXThe pilot’s loss of airplane control for reasons that could not be determined from the available information.NTSB CEN11FA437Accident · 3 fatalField investigationFinal reportAmerican Champion 7GCBC · Hayti, SDThe pilot's decision to attempt low-altitude flight and his failure to maintain adequate clearance from power lines.NTSB CEN11CA462Accident · No injuriesData collectionFinal reportMooney M20S · Washington Island, WIThe pilot's failure to maintain aircraft control during the landing and his delayed remedial action to abort the landing.NTSB WPR11FA302Accident · 1 fatalField investigationFinal reportSchleicher ASW-20 · Lone Pine, CAThe glider encountered a strong downward orographic wind flow and turbulence that forced it into terrain. Also causal was the pilot’s decision to operate the glider very close to the terrain.NTSB WPR11CA308Accident · Minor injuriesData collectionFinal reportPiper PA-18 · Enumclaw, WAThe pilot's failure to maintain an adequate airspeed during an encounter with a mountain wave and downdraft landing.NTSB ERA11LA386Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301 · Louisville, KYThe pilot's improper flare and inadequate recovery from a bounced landing, which resulted in a landing gear collapse.NTSB ERA11FA374Accident · 1 fatalField investigationFinal reportBinkley Richard Sonex · Calhoun, GAThe total loss of engine power for reasons that could not be determined because postimpact fire damage precluded a thorough examination of the engine.NTSB ERA11FA376Accident · 5 fatalField investigationFinal reportCessna A185F · Yabucoa, PRThe pilot's inadequate weather planning and improper decision to continue a visual flight rules flight into instrument meteorological conditions, which resulted in an encounter with a thunderstorm and subsequent loss of control.NTSB CEN11LA441Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Flippin, ARThe loss of engine power due to improper maintenance and resultant oil starvation.NTSB ERA11LA399Accident · No injuriesLimited investigationFinal reportCessna 182K · Stevensville, MDA total loss of engine power during initial climb for undetermined reasons.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 CEN11FA436Accident · 1 fatalField investigationFinal reportRay Aerial Spraying 773 Racer · Ottumwa, IAThe loss of engine power for reasons that could not be determined because postaccident examination of the airplane’s engine and ignition system did not reveal any anomalies that would have precluded normal operation, and extensive postaccident fire damage…NTSB CEN11FA434Accident · 1 fatalField investigationFinal reportSchaffer Gary W Lancair · Yukon, OKThe pilot's use of an excessive bank angle while in the airport traffic pattern, which resulted in an accelerated stall. Contributing to the accident were the pilot’s lack of experience in the airplane and the pilot’s distracted attention to the rough running…NTSB CEN11FA433Accident · 1 fatalField investigationFinal reportKlemp Gregory J Challenger II · Neshkoro, WIThe total loss of engine power during the initial climb due to a cold seizure as a result of a broken fan V-belt. Contributing to the accident was the passenger's interference with the flight controls during the forced landing.NTSB CEN11CA453Accident · Serious injuriesData collectionFinal reportPowrachute Airwolf 912 · Oconto, WIThe powered parachute pilot's decision to execute an in-flight full-flare which resulted in exceeding the angle of attack capabilities of the parachute wing, and subsequent inadvertent stall.NTSB CEN11LA429Accident · Minor injuriesLimited investigationFinal reportKeesler W8 Tailwind · Oshkosh, WIThe loss of engine power during initial climb for undetermined reasons.NTSB CEN11FA431Accident · 2 fatalField investigationFinal reportBosonetto Thorp T-18 · Howell, MIThe pilot's failure to maintain airplane control and airspeed during final approach, which resulted in an aerodynamic stall/spin at a low altitude.