NTSB investigations
4,605 cases where the first occurrence was “In flight collision with object”.
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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220) 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220) 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 FTW93LA257Accident · 1 fatalLimited investigationFinal reportBeech C-45H · Fentress, TXInadvertent deployment of the skydiver's reserve parachute for undetermined reasons.NTSB LAX93LA342Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Hesperia, CAThe aircraft's encounter with a low level windshear and the pilot's inadequate compensation for the existing wind conditions.NTSB BFO93LA156Accident · 1 fatalLimited investigationFinal reportCessna 172P · Pembroke, VAThe pilot's failure to maintain proper altitude while manuevering in mountainous terrain.NTSB NYC93LA173Accident · Serious injuriesLimited investigationFinal reportCameron Bieu/V-65 · Lewiston, NYThe pilot's failure to maintain adequate clearance, which resulted in an inflight collision with a light pole.NTSB LAX93LA331Accident · Serious injuriesLimited investigationFinal reportUltimate 10-80 · Chandler, AZThe noncertificated pilot's failure to follow the prescribed VFR procedures and poor visual lookout. The other aircraft pilot's restricted visual lookout was a factor in this accident.NTSB NYC93LA162Accident · No injuriesLimited investigationFinal reportCessna 150 · Mcgaheysville, VAThe flight instructor's inadequate supervision resulting in a delayed go-around.NTSB NYC93LA161Accident · Serious injuriesLimited investigationFinal reportBeech A23 · Morgantown, WVThe pilot's failure to follow IFR procedures in which he descended below the decision height without visual detection of the runway. Factors are the fog conditions, trees and the pilot's inattention to altitude.NTSB MIA93LA178Accident · Minor injuriesLimited investigationFinal reportSchweizer G-164B · Benton, MSThe pilot-in-command's failure to maintain proper visual outlook.NTSB MIA93LA176Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Immokalee, FLThe pilot-in-command's failure to maintain airspeed (vs) while maneuvering resulting in a stall/mush.NTSB CHI93DEE05Accident · Serious injuriesFinal reportWeatherly 620 · Mendota, ILThe pilot-in-command's failure to maintain clearance fom powerlines during an aerial application manuever.NTSB LAX93LA319Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Dixon, CAthe failure of the pilot to visually detect and avoid the guy wire.NTSB CHI93LA316Accident · No injuriesLimited investigationFinal reportCessna A188B · Lexington, NEobstacle clearance not maintained by the pilot-in-command.NTSB LAX93FA316Accident · Serious injuriesField investigationFinal reportBell 206L1 · Tusayan, AZFailure of the pilot of N444CR to maintain adequate main rotor clearance from N38903, and the operator's failure to provide adequate or recommended safe helipad dimensions. A factor in the accident was the lack of visual reference to the rotating blades of…NTSB FTW93LA232Accident · No injuriesLimited investigationFinal reportCessna 182A · Killeen, TXThe pilot's inadequate compensation for wind conditions. Factors were the gusty crosswinds.NTSB FTW93LA231Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Salida, COThe climb capability of the airplane being exceeded and the pilot's decision to turn into the rising terrain. A factor was the high density altitude.NTSB NYC93LA142Accident · No injuriesLimited investigationFinal reportCessna 152L · East Berne, NYthe pilot's inadequate preflight planning for a departure from a short field and his failure to attain a proper climb rate, resulting in an in-flight collision with a 5 foot pole located on rising terrain, 20 feet above the airport elevation.NTSB CHI93LA305Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B · Clarinda, IAThe commercial pilot's failure to maintain adequate clearance from obstacles during aerial application maneuvers.NTSB DEN93LA095Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Pagosa Springs, COThe decision by the pilot in command to fly at an altitude insufficient for the surrounding terrain. Factors were: the pilot's attention being momentarily diverted and the airplane's climb performance being exceeded.NTSB DEN93LA093Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Brookland, ARThe pilot's failure to maintain adequate object clearance.NTSB CHI93LA299Accident · No injuriesLimited investigationFinal reportCessna 170B · Steele, NDThe pilot-in-command's poor in-flight decision and failure to maintain proper clearance.NTSB LAX93LA303Accident · No injuriesLimited investigationFinal reportAyres S2R · Stratford, CAThat the pilot misjudged the airplane's altitude. Factors relating to this accident were the pilot's fatigue and the light conditions.NTSB CHI93LA291Accident · Serious injuriesLimited investigationFinal reportBeech A-36 · Houghton, MIthe pilot-in-command not following instrument procedures by not using the correct altimeter setting as issued by Air Traffic Control.NTSB DEN93FA089Accident · 1 fatalField investigationFinal reportGlobe GC-1B · Durango, COThe pilot's entry into a box canyon at an altitude insufficient to clear mountainous terrain.NTSB CHI93LA284Accident · No injuriesLimited investigationFinal reportCessna 177RG · Columbus, INthe pilot in command's failure to maintain proper clearance. A factor involved in this accident is the pilot in command's failure to maintain a proper glidepath.NTSB ANC93LA126Accident · No injuriesLimited investigationFinal reportCessna 207 · Egegik, AKThe pilot-in-command's failure to see and avoid the truck.NTSB NYC93FA138Accident · 2 fatalField investigationFinal reportRobinson R22 · Warsaw, KYThe pilot's inadequate visual lookout and his failure to maintain adequate clearance with ground obstacles, which resulted in an inflight collision with a power line.NTSB FTW93LA217Accident · No injuriesLimited investigationFinal reportCessna 172P · Cookson, OKThe pilot's improper flare and his failure to maintain directional control during the aborted landing.NTSB CHI93DEP02Accident · 1 fatalFinal reportStoeckler RV-4 · Lake Delton, WIthe pilot-in-command's failure to maintain proper altitude. A factor was trees.NTSB BFO93FA135Accident · 2 fatalField investigationFinal reportKrowell Christen Eagle II · Lebanon, NHInadequate crew/group coordination.NTSB LAX93FA297Accident · 2 fatalField investigationFinal reportCessna 175B · Blythe, CAThe pilot's failure to see and avoid the cable due to drug impairment. Factors which contributed to the accident were: the pilot's intentional buzzing, his ostentatious display, and his failure to maintain an adequate altitude over the river.NTSB MIA93FA160Accident · 4 fatalField investigationFinal reportPiper PA-28 · Morriston, FLVFR flight by the pilot(s) into instrument meteorological conditions (IMC) and failure to maintain adequate altitude (or clearance) from the tower. The proximity of the tower/guy wires and weather condition were related factors.NTSB CHI93LA269Accident · 1 fatalLimited investigationFinal reportBeech A23 · Boyceville, WIthe failure of the pilot to attain the proper touchdown point, and his failure to perform a go-around.NTSB BFO93FA128Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-65 · Danbury, CTUndetermined.NTSB SEA93FA153Accident · 1 fatalField investigationFinal reportPiper PA-34-220T · Battleground, WAThe pilot in command's failure to maintain adequate altitude during his maneuver.NTSB LAX93LA290Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T34 · Buckeye, AZthe pilot's failure to visually detect and avoid a power line. A factor in the accident was the twilight light condition.NTSB CHI93LA259Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Vassar, MIThe pilot's inadequate compensation for the crosswind.NTSB MIA93GA154Accident · 4 fatalFinal reportSikorsky UH-60A · Hortense, GAThe pilot-in-command's inadequate supervision of the flight, the co-pilot's failure to maintain an adequate altitude, and the failure of both pilots to see and avoid the wires. Contributing to the accident was the pilot-in-command's inadequate preflight…NTSB LAX93LA288Accident · 2 fatalLimited investigationFinal reportRobinson R22B · Weimar, CAThe failure of both pilots to see and avoid the charted power line. Factors which contributed to the accident were: the failure of the utility companies to adequately review the hazard posed by the wires following a previous collision at the same location,…NTSB CHI93LA251Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Clarence, MOIs the pilot in command's failure to maintain proper clearance. A factor to the accident were the trees at the end of the field to be sprayed.NTSB SEA93LA157Accident · No injuriesLimited investigationFinal reportCessna 150L · Ontario, ORThe pilot in command's failure to maintain proper clearance. A factor contributing to the accident was the pilot in command's delayed go around.NTSB MIA93LA153Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Jacksonville, FLFailure of the pilot in command to maintain directional control during the landing. Contributing to the accident was the excessive airspeed while landing and failure of the pilot to recover from the bounced landing.NTSB FTW93LA212Accident · No injuriesLimited investigationFinal reportCessna A188B · Temple, TXPilot's failure to maintain proper object/terrain clearance. Factors were tailwinds and high density altitude.NTSB FTW93LA208Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Baton Rouge, LAThe student pilot's failure to abort the landing in a timely manner and his failure to maintain directional control.NTSB CHI93LA244Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-160 · California, MOThe pilot in command's failure to maintain adequate airspeed.NTSB BFO93LA109Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Mayville, NYThe pilot's failure to select the proper runway for takeoff, and his failure to maintain clearance with terrain. A factor related to the accident was a prevailing tailwind.NTSB ATL93LA123Accident · 1 fatalLimited investigationFinal reportGulfstream G-164B · Selmer, TNThe pilot's failure to maintain adequate clearance from the power lines.NTSB BFO93FA129Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · California, MDThe pilot initiating VFR flight in instrument meteorological conditions. Factors which contributed to the accident were: the pilot's failure to obtain a weather briefing, his lack of sleep, and the existing weather conditions.NTSB ANC93FA107Accident · Minor injuriesField investigationFinal reportCessna 185 · Wasilla, AKThe pilot in command's failure to use all of the available runway (waterway). A factor in the accident was the pilot in command's lack of recent experience in the type of operation.NTSB CHI93LA240Accident · No injuriesLimited investigationFinal reportCessna R172K · Rice, MNThe pilot in command's failure to maintain proper clearance.NTSB SEA93LA142Accident · Serious injuriesLimited investigationFinal reportWeatherly 201B · Wilbur, WAVisual lookout was not maintained. The wires were a factor.