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 WPR12CA336Accident · No injuriesData collectionFinal reportPiper PA28-150 · Yellow Pine, IDThe pilot's failure to attain and maintain an appropriate glide path, failure to perform a go-around, and failure to maintain directional control during the landing roll.NTSB CEN12LA490Accident · Serious injuriesLimited investigationFinal reportSmith Applebay Zuni II · Gregory, MIThe glider pilot’s failure to maintain sufficient altitude and airspeed while turning to the base leg of the traffic pattern, which resulted in a stall/spin and impact with trees and terrain.NTSB WPR12CA337Accident · Minor injuriesData collectionFinal reportCessna 172 · Grand Canyon, AZThe pilot’s improper flare and inadequate recovery from a bounced landing.NTSB WPR12CA330Accident · No injuriesData collectionFinal reportAlon A2 · Compton, CAThe pilot's failure to maintain directional control during landing.NTSB ERA12LA503Accident · No injuriesLimited investigationFinal reportBeech 95-A55 · Homerville, GAThe loss of engine power due to debris within the engine-driven fuel pump.NTSB ERA12LA486Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Blacksburg, VAThe pilot’s inadequate preflight planning and improper in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN12FA487Accident · No injuriesField investigationFinal reportMooney M20TN · Adrian, MIAn initial nose-pitch-up event and out-of-trim condition, the reason for which could not be determined because the examinations of the airplane did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the…NTSB CEN12CA484Accident · Serious injuriesData collectionFinal reportBell 47G-2A · Austin, INThe pilot did not maintain clearance from terrain during a low-level aerial application flight and lost control of the helicopter.NTSB WPR12FA326Accident · 3 fatalField investigationFinal reportBeech B60 · Sedona, AZThe airplane’s failure to rotate and the pilot’s failure to reject the takeoff, which resulted in a runway overrun for reasons that could not be undetermined because postaccident examination of the airplane and engines did not reveal any malfunctions or…NTSB ERA12LA482Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Green Creek, NJThe pilot's inadequate fuel planning, which resulted in a total loss of engine power due to fuel starvation while maneuvering.NTSB ERA12CA485Accident · No injuriesData collectionFinal reportBayliss Milton A III X-AIR · Houlton, METhe pilot's failure to maintain directional control during the landing flare in a gusting crosswind, which resulted in a runway excursion.NTSB ANC12FA079Accident · Minor injuriesField investigationFinal reportBeechcraft F33A · Fairbanks, AKThe total loss of engine power reason that could not be determined because postaccident examination and test run did not reveal any anomalies that would have precluded normal operation.NTSB ERA12FA484Accident · 1 fatalField investigationFinal reportCessna 172M · San Juan, PRMaintenance personnel’s improper lubrication of the right direct aileron control cable and failure to detect the severe corrosion of the cable during a maintenance inspection, which resulted in the in-flight failure of the cable, the pilot’s subsequent…NTSB CEN12LA481Accident · No injuriesLimited investigationFinal reportRaytheon B36TC · Sugar Grove, ILThe partial loss of engine power for reasons that could not be determined because postaccident testing and examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN12LA480Accident · Minor injuriesLimited investigationFinal reportScotts-Bell 47 47G-2A · Akeley, MNThe pilot’s failure to maintain helicopter control during low altitude agricultural operations.NTSB CEN12CA486Accident · No injuriesData collectionFinal reportMooney M20M · Heber Springs, ARThe pilot's improper flare, which led to a bounced landing and a subsequent loss of control.NTSB CEN12CA482Accident · No injuriesData collectionFinal reportNelson Miles Sky Star Kitfox · Weatherford, TXThe pilot's failure to maintain directional control during the landing flare. Contributing to the accident was the pilot’s delay in aborting the landing.NTSB WPR12TA323Accident · No injuriesFinal reportAero Commander 500 S · Elko, NVA loss of power due to fuel exhaustion. Contributing to the accident were the pilot's failure to comply with required fueling procedures and the pilot's poor decision-making in not monitoring his fuel gauge and turning back when it reached minimum fuel.NTSB ERA12LA477Accident · No injuriesLimited investigationFinal reportHughes 269C · St. Petersburg, FLThe pilot's failure to assure that the lateral friction control was released prior to flight.NTSB ERA12CA476Accident · No injuriesData collectionFinal reportMooney M20TN · Hilton Head, SCThe pilot’s failure to maintain directional control while landing in a crosswind.NTSB WPR12CA319Accident · No injuriesData collectionFinal reportDornier DO 27 B5 · Jackson Hole, WYThe pilot's selection of unsuitable terrain for landing, resulting in the collapse of the main landing gear.NTSB ERA12LA480Accident · No injuriesLimited investigationFinal reportCessna A185F · Mapleton, METhe pilot’s improper fuel management, which resulted in fuel starvation and a total loss of engine power, and his use of an improper engine restart procedure.NTSB ERA12LA473Accident · No injuriesLimited investigationFinal reportCirrus Design SR-22 · Pickens, SCA total loss of engine power due to the failure of the crankshaft, which resulted from the application of insufficient torque on the cylinder through-bolts by maintenance personnel.NTSB CEN12LA477Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Leander, TXThe partial loss of engine power due to carburetor ice accumulation, which resulted in the airplane’s reduced climb performance and subsequent impact with trees off the end of the runway.NTSB CEN12CA469Accident · Serious injuriesData collectionFinal reportPurtee Kevin M Pietenpol Aircamper · Broadhead, WIThe pilot's failure to adequately remove water-contaminated fuel during the preflight inspection, which resulted in a total loss of engine power during takeoff, and his decision to initiate a turn back to the runway with insufficient airspeed, which resulted…NTSB WPR12LA318Accident · Serious injuriesLimited investigationFinal reportRepublic RC-3 · Snohomish, WALoss of engine power during takeoff 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 WPR12LA317Accident · Serious injuriesLimited investigationFinal reportHerem DR-107 · Bridger, MTThe pilot’s failure to maintain airplane control while maneuvering after takeoff.NTSB WPR12FA316Accident · Serious injuriesField investigationFinal reportCessna 182P · Corona, CAA loss of engine power shortly after takeoff for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation. Contributing to the accident was the pilot’s decision to take off…NTSB WPR12CA338Accident · No injuriesData collectionFinal reportAerotrek A220 · Bremerton, WAThe pilot’s failure to maintain airplane control during an attempted go-around in gusting wind conditions.NTSB ERA12LA470Accident · Minor injuriesLimited investigationFinal reportCessna 182A · Farmingdale, NJThe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA12CA475Accident · No injuriesData collectionFinal reportPiper PA-20 · Cooperstown, NYThe pilot's inadequate compensation for crosswind conditions during takeoff, which resulted in a loss of directional control.NTSB CEN12LA483Accident · Serious injuriesLimited investigationFinal reportEipper Quicksilver MXL II · Goodrich, MIThe operation of an unregistered and unairworthy airplane by a non-certificated pilot. Contributing to the accident was the non-certificated pilot’s improper preflight inspection, which resulted in a total loss of engine power due to water/debris…NTSB CEN12LA467Accident · Serious injuriesLimited investigationFinal reportBeech A24R · Miami, TXAn in-flight loss of control on final approach for undetermined reasons.NTSB CEN12FA462Accident · 2 fatalField investigationFinal reportNanchang China CJ-6A · Walsenburg, COThe pilot's failure to maintain airplane control while turning from base to final leg in the traffic pattern.NTSB CEN12CA465Accident · Serious injuriesData collectionFinal reportMooney M20J · Oshkosh, WIThe pilot’s excessive airspeed at touchdown and his loss of control of the airplane during the landing roll.NTSB CEN12CA464Accident · Serious injuriesData collectionFinal reportBertram William J Bertram 2000 · Shiocton, WIThe pilot’s distraction with taking photographs, which resulted in his failure to maintain sufficient altitude to avoid the guy wire.NTSB WPR12LA324Accident · No injuriesLimited investigationFinal reportHawker Beechcraft G58 · Medford, ORA loss of directional control on landing for reasons that could not be determined based on the available evidence.NTSB WPR12LA315Accident · No injuriesLimited investigationFinal reportPiper PA-32S-300 · Adelanto, CAThe pilot’s failure to maintain directional control during the aborted takeoff, which was aborted due to fuel starvation as a result of an inadvertent in-flight activation of the fuel drain activation lever by the passenger. Contributing to the accident was…NTSB ERA12LA469Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Statesboro, GAA total loss of engine power as a result of oil exhaustion due to the mechanic's failure to apply appropriate torque to the oil filter.NTSB ERA12FA467Accident · 1 fatalField investigationFinal reportBrenholt Larry R RV-4 · Cedartown, GAThe non-instrument-rated pilot's continued visual flight into instrument meteorological conditions and his failure to maintain airspeed while maneuvering for a forced landing, which resulted in an aerodynamic stall and collision with terrain.NTSB CEN12CA461Accident · No injuriesData collectionFinal reportMooney M20K · Hutchinson, MNThe student pilot’s inadequate flare and failure to maintain directional control during landing, which resulted in a runway excursion and subsequent impact with obstructions.NTSB ANC12CA077Accident · No injuriesData collectionFinal reportBell 206L-3 · Circle, AKThe pilot's selection of unsuitable terrain for landing.NTSB CEN12LA485Accident · No injuriesLimited investigationFinal reportMooney M20E · Englewood, COThe pilot's loss of directional control during landing.NTSB ANC12FA066Accident · 2 fatalField investigationFinal reportPiper PA-32R-301 · Fairbanks, AKThe noninstrument-rated pilot's decision to continue visual flight into instrument meteorological conditions likely leading to spatial disorientation, which resulted in a loss of airplane control and in-flight structural failure.NTSB CEN12LA453Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-402B · Britt, IAThe pilot’s failure to maintain clearance from power transmission lines during an agricultural application operation. Contributing to the accident was the pilot’s distracted attention due to personal cell phone use during flight operations.NTSB ERA12FA458Accident · 1 fatalField investigationFinal reportBeech A23 · Laytonsville, MDThe pilot’s failure to ensure that the fuel selector handle was correctly positioned, which resulted in an interruption of fuel to the engine and a loss of engine power during the takeoff, which necessitated a turn away from the trees at the end of the runway…NTSB ERA12CA464Accident · No injuriesData collectionFinal reportPiper PA32-301FT · Brevard, NCThe pilot’s failure to execute a go-around following an approach that was high and fast, which resulted in a runway overrun.NTSB ERA12CA462Accident · Serious injuriesData collectionFinal reportInfinity Infinity 2003 · Wilmore, KYA loss of lift on initial climb for unreported reasons, which resulted in a collision with trees and the ground.NTSB ERA12CA460Accident · Minor injuriesData collectionFinal reportCessna T206H · Glens Falls, NYThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB CEN12IA451Incident · No injuriesIncident investigationFinal reportFlight Design Ctls · Marysville, OHFatigue failure of the left main wheel assembly on takeoff, which resulted in a loss of directional control and runway excursion.