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 MIA08MA051Accident · 2 fatalMajor investigationFinal reportCessna 525 · West Gardiner, METhe pilot's spatial disorientation and subsequent failure to maintain airplane control.NTSB LAX08LA056Accident · No injuriesLimited investigationFinal reportSmith Zodiac 601XL · Murrieta, CAA loss of engine power due to fuel starvation, which was induced by the electrical system lacking sufficient power to run all of the electrical devices on the airplane and the electrical fuel pump.NTSB MIA08CA049Accident · Serious injuriesData collectionFinal reportAirborne Redback · Jefferson, GAThe failure of the pilot-in-command to maintain control of the airplane and his poor weather evaluation before attempting to taxi the airplane. A factor in the accident was the failure of airport personnel to correct the inaccurate wind information reported…NTSB LAX08CA054Accident · No injuriesData collectionFinal reportBell OH-58A · Brawley, CAThe pilot's failure to maintain clearance from obstacles. A factor in the accident was the dark night conditions.NTSB NYC08CA094Accident · Minor injuriesData collectionFinal reportPiper J3-C65 · Hollywood, FLThe pilot's failure to maintain directional control while landing. Contributing was the gusty crosswind condition.NTSB MIA08CA047Accident · No injuriesData collectionFinal reportCessna 150J · Dawson, GAThe pilot's failure to maintain directional control during landing roll out.NTSB NYC08LA087Accident · 1 fatalLimited investigationFinal reportUnknown Free Bird Sportlite · McCullough, ALThe non-certificated pilot's failure to maintain aircraft control while maneuvering. Contributing to the accident was the non-certificated pilot's improper decision to conduct a flight prior to the airplane being properly inspected and certified.NTSB DFW08CA059Accident · Serious injuriesData collectionFinal reportPiper PA-18-150 · Sheffield, TXThe pilot's failure to maintain sufficient airspeed while maneuvering which resulted in a stall.NTSB CHI08CA072Accident · No injuriesData collectionFinal reportAvid MK-IV · Boswell, INThe pilot's inadequate compensation for the crosswind condition which resulted in a loss of directional control during a bounced landing. Factors associated with the accident were the improper flare, the crosswind, and the trees which the airplane contacted.NTSB DEN08LA053Accident · Serious injuriesLimited investigationFinal reportPhillips Flite Bike · Valley Center, KSThe pilot's failure to maintain airspeed during an emergency descent resulting in an inadvertent stall/mush. Contributing to the accident was the pilot's failure to turn on the fuel tank valve resulting in fuel starvation and the loss of engine power.NTSB DEN08LA054Accident · No injuriesLimited investigationFinal reportMacAdams Titan Tornado 912 · Rock Springs, WYThe loss of engine power for undetermined reasons. Contributing to the accident was the snow covered ravine.NTSB MIA08FA044Accident · 2 fatalField investigationFinal reportRobinson R44 · Ochopee, FLThe pilot's failure to maintain aircraft control while maneuvering. Contributing to the accident were a tailwind condition and the pilot's inadequate in-flight planning/decision.NTSB CHI08CA069Accident · No injuriesData collectionFinal reportCessna 172N · South St. Paul, MNThe student pilot's failure to maintain directional control of the airplane during the landing roll. Contributing to the accident were the snow-covered runway and the gusty wind conditions.NTSB MIA08LA043Accident · No injuriesLimited investigationFinal reportCessna U206F · Kissimmee, FLThe probable cause of this accident is undetermined.NTSB NYC08CA085Accident · No injuriesData collectionFinal reportQuicksilver Sport 2S · Arley, ALA malfunction of the rudder control system.NTSB LAX08LA050Accident · 2 fatalLimited investigationFinal reportAir Creation Clipper · Green Valley, AZAn in-flight loss of control and an uncontrolled descent into terrain for undetermined reasons.NTSB LAX08CA048Accident · Minor injuriesData collectionFinal reportWaltermire Glastar · Vacaville, CAThe pilot's failure to maintain directional control during landing and a lack of experience in conventional gear airplanes.NTSB DFW08FA057Accident · 1 fatalField investigationFinal reportPiper PA46-500TP · San Antonio, TXThe pilot's failure to execute an instrument approach. Contributing to the accident was the pilot's impairment due to recent use of over-the-counter medication.NTSB DEN08CA051Accident · No injuriesData collectionFinal reportPiper PA-32-301XTC · Taos, NMThe pilot's excessive airspeed during the approach and loss of control during the landing. Contributing factors were the mountain turbulence and the snowbank.NTSB ANC08LA032Accident · Serious injuriesLimited investigationFinal reportCessna 207 · Aniak, AKA partial loss of engine power for an undetermined reason. Contributing to the accident were the pilot's inadvertent encounter with IMC conditions, and a whiteout during his attempted go-around from an emergency landing approach.NTSB ANC08LA031Accident · Minor injuriesLimited investigationFinal reportCessna 208B · Bethel, AKThe pilot's selection of unsuitable terrain for landing. Contributing to the accident were snow-covered terrain, blowing snow and flat lighting conditions.NTSB SEA08LA060Accident · No injuriesLimited investigationFinal reportDeSousa Jabiru J400 · Santa Monica, CAThe pilot's failure to attain the proper touchdown point, and loss of the wheel brake system.NTSB MIA08CA042Accident · No injuriesData collectionFinal reportPiper PA-32-260 · Atlanta, GAThe failure of the pilot-in-command to maintain directional control of the airplane during landing.NTSB SEA08CA059Accident · No injuriesData collectionFinal reportBell 206 B2 · La Verna, CAThe pilot's improper preflight planning which resulted in a jammed cyclic control while maneuvering.NTSB MIA08FA038Accident · 3 fatalField investigationFinal reportCessna 172L · Clearwater, FLThe pilot's failure to maintain airspeed while maneuvering for approach to land. Contributing to the accident was the pilot's operation of the airplane above the design gross weight.NTSB MIA08CA039Accident · No injuriesData collectionFinal reportPiper PA-32-300 · Lapine, ALThe pilot's failure to attain the proper touchdown point.NTSB DEN08LA049Accident · No injuriesLimited investigationFinal reportCessna 172M · Pine Bluffs, WYThe pilot's failure to maintain control of the airplane. Contributing factors in this accident were the unfavorable wind and the snow bank.NTSB CHI08FA061Accident · 4 fatalField investigationFinal reportCessna 340 · Port Clinton, OHThe pilot's failure to maintain sufficient airspeed to avoid a stall during the landing approach.NTSB NYC08CA079Accident · No injuriesData collectionFinal reportCessna 150G · Sarasota, FLThe pilot's improper preflight and in-flight planning which resulted in a loss of engine power due to fuel exhaustion.NTSB CHI08IA065Incident · No injuriesIncident investigationFinal reportBoeing 737-2H4 · Lincoln, NEThe improper installation of the swivel valve fittings by the operator's mechanic leading to the total loss of both hydraulic systems. Contributing to the incident were the swivel valves leaking and the total failure of the hydraulic system.NTSB NYC08LA075Accident · Minor injuriesLimited investigationFinal reportDean Patrick G Genesis · Laurel, MDThe reason for this occurrence was undetermined.NTSB MIA08LA035Accident · Minor injuriesLimited investigationFinal reportCessna R172K · Spotsylvania, VAThe pilot's failure to follow the checklist and failure to achieve the proper touchdown point during a forced landing. Contributing to the accident was a loss of engine power due to a cracked No. 4 top sparkplug insulator, resulting in pre-ignition/detonation…NTSB ANC08MA038Accident · 6 fatalMajor investigationFinal reportPiper PA-31-350 · Kodiak, AKThe failure of company maintenance personnel to ensure that the airplane's nose baggage door latching mechanism was properly configured and maintained, resulting in an inadvertent opening of the nose baggage door in flight. Contributing to the accident were…NTSB DEN08CA047Accident · No injuriesData collectionFinal reportCessna 152 · Loveland, COthe student pilot's premature flare resulting in the loss of aircraft control.