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 FTW94FA168Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Wingate, TXWas the pilot's failure to maintain proper alignment. Factors were the wind, and the pilot's improper corrections.NTSB CHI94LA166Accident · Serious injuriesLimited investigationFinal reportGrumman G-164 · Hillsboro, NDthe pilot's failure to maintain clearance from a tree.NTSB CHI94LA158Accident · Minor injuriesLimited investigationFinal reportAeronca 11AC · Montello, WIthe pilot's inadequate compensation for the wind conditions. A factor related to the accident was the crosswind.NTSB CHI94LA161Accident · No injuriesLimited investigationFinal reportBell 206B · Winnebago, ILa wire strike due to failure to maintain proper altitude, and improper visual lookout by the pilot-in-command.NTSB LAX94FA214Accident · 2 fatalField investigationFinal reportRobinson R-22 · Hacienda Height, CAThe pilot's selection of an en route cruise altitude which provided insufficient obstruction clearance, and his inadequate visual lookout. Factors in the night time accident were the reduced visibility as a result of the fog and haze.NTSB ATL94LA094Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Stone Mountain, GAthe pilot's improper vertical takeoff in that he allowed the helicopter to drift rearward, and his failure to maintain clearance from the wire.NTSB NYC94FA078Accident · 2 fatalField investigationFinal reportRobinson R22A · North Bergen, NJThe pilot's failure to maintain adequate visual lookout and adequate obstacle clearance, which resulted in an inflight collision with a static wire.NTSB CHI94LA162Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Alexandria, NEThe pilot's failure to maintain clearance with wires.NTSB LAX94LA208Accident · No injuriesLimited investigationFinal reportBell UH-1L · Pleasant Grove, CAthe pilot's failure to see and avoid the power lines due to sun glare from the rising sun at dawn.NTSB FTW94LA142Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Lindon, COInaccurate preflight planning and preparation for the flight. A factor was soft terrain on the landing strip.NTSB SEA94LA113Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Monarch, MTPoor in flight planning/decision. A factor to the accident was downdrafts.NTSB ATL94LA087Accident · No injuriesLimited investigationFinal reportCessna 182B · Ellijay, GAThe inadvertent deployment of the parachute because of the jumpmaster's inattention to the static line.NTSB BFO94LA078Accident · Minor injuriesLimited investigationFinal reportCameron ET-90 · Louisville, KYThe pilot-in-command's failure to maintain clearance from wires during the landing approach. A factor related to the accident is a downdraft that exceeded the balloon's available climb capability.NTSB SEA94LA109Accident · Minor injuriesLimited investigationFinal reportBell 206B · Summerville, ORThe pilot did not maintain clearance from the wires. The overcast sky condiiton was a factor.NTSB ATL94LA086Accident · No injuriesLimited investigationFinal reportFerguson Fergy II · Nashville, TNThe pilot's failure to maintain clearance from a utility wire during climbout.NTSB FTW94LA132Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCAA · Azle, TXThe instructor pilot's failure to maintain terrain and obstacle clearance. A factor was the instructor's diverted attention.NTSB LAX94LA199Accident · 1 fatalLimited investigationFinal reportContinental Copters Tomcat MK5A · Brawley, CAFailure of the pilot to maintain sufficient altitude, while maneuvering to land after completing aerial application. Factors related to the accident were: darkness and the lack of visual cues for the pilot to detect the obstruction (power line).NTSB CHI94FA137Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Marshfield, MOFailure of the pilot to maintain proper altitude during a VFR flight into IMC conditions.NTSB FTW94FA123Accident · 1 fatalField investigationFinal reportSIAI-Marchetti F.260C · Watson, ARThe pilot's failure to maintain adequate clearance from wires during low level flight which resulted in a severed aileron cable. Factors were the pilot's failure to maintain adequate altitude during the flight and his inability to control the airplane…NTSB ATL94LA083Accident · No injuriesLimited investigationFinal reportCessna 172K · Spartanburg, SCThe inadequate visual lookout by the pilot of Cessna 172K, N711GT.NTSB FTW94LA126Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-260 · Muskogee, OKThe pilot's failure to maintain clearance with the power line. Factors were a chemical spray contaminated windscreen, the resultant limitation to visibility, and sun glare.NTSB CHI94LA131Accident · No injuriesLimited investigationFinal reportCessna 172 · Edina, MOthe pilot in commands' failure to obtain obstruction clearance from trees during a visual takeoff from a short, soft, wet field in instrument meteorological conditions. A factor was the pilot in commands' misjudgment of the takeoff climb performance of the…NTSB CHI94LA130Accident · Serious injuriesLimited investigationFinal reportCessna 182P · Chesterfield, MOFailure of the pilot to follow proper IFR procedures and maintain proper altitude during the approach. Factors related to the accident were: darkness, the weather conditions, and failure of the approach controller to issue an IFR transponder code to the…NTSB CHI94LA129Accident · Minor injuriesLimited investigationFinal reportSchweizer 269C · Hebron, NEThe failure of the student pilot to maintain adequate clearance from obstructions during aerial taxi.NTSB ANC94LA048Accident · No injuriesLimited investigationFinal reportCessna A185F · Paxson, AKThe pilot-in-command did not maintain proper clearance from the snow berm. A factor in the accident was the snow berm.NTSB LAX94LA176Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Gasquet, CAThe failure of the pilot to adequately compensate for the cross- wind conditions, and to maintain proper alignment with the runway.NTSB BFO94LA058Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · New Castle, DEInadequate clearance from obstacles, which resulted in birds strike. A factor was night conditions.NTSB NYC94LA061Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Hopedale, MAthe certified flight instructor's delay in taking remedial action by not initiating the go-around, resulting in the in-flight collision with the tree.NTSB ATL94LA067Accident · 1 fatalLimited investigationFinal reportCessna 140 · Celina, TNThe pilot's failure to maintain a proper altitude, and his failure to maintain clearance from the transmission wire.NTSB FTW94LA100Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Albuquerque, NMThe CFI rated second pilot's failure to maintain the ILS glideslope. A factor was the dark night and lack of supervision.NTSB FTW94LA098Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Moro, ARThe pilot's failure to maintain clearance of power lines.NTSB SEA94LA081Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Dubois, IDThe pilot's inadequate visual lookout. Factors include light conditions at dusk.NTSB LAX94FA157Accident · 3 fatalField investigationFinal reportPiper PA-32R-301T · Napa, CAthe pilot's selection of an en route descent altitude profile inadequate to clear all terrain along his intended flight path, and, his inadvertent VFR flight into IMC conditions. Factors in the accident were the dark night lighting conditions and the obscured…NTSB SEA94LA079Accident · Minor injuriesLimited investigationFinal reportKelley Stits SA6B · Snohomish, WAThe pilot's failure to maintain adequate airspeed. Factors include a pole off the departure end of the runway.NTSB FTW94LA092Accident · No injuriesLimited investigationFinal reportRockwell 690C · Hayden, COFailure by the pilot to maintain proper altitude. A factor was dark night conditions.NTSB SEA94LA070Accident · No injuriesLimited investigationFinal reportCessna 172 · Casper, WYThe pilot's failure to maintain proper alignment with the runway. The crosswind was of factor.NTSB LAX94LA128Accident · 1 fatalLimited investigationFinal reportStinson 108-3 · Redlands, CAThe pilot's impairment of judgment and performance due to alcohol, which led to his improper planning/decision, and his failure to maintain proper altitude. Factors related to the accident were: darkness and the pilot's lack of training/certification for…NTSB ATL94LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Smithfield, NCThe pilot's failure to maintain adequate clearance from power lines. Factors were the unmarked power lines located under the final approach path, and the sun glare that existed at the time of the accident.NTSB CHI94LA084Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Eden Prairie, MNThe pilot's poorly planned approach and remaining below a proper glide path during final approach. The pilot's lack of total expereince was a factor.NTSB BFO94LA039Accident · Serious injuriesLimited investigationFinal reportCessna 120 · Chittenango, NYThe pilot's inadequate planning/decision to take off with the presence of a tailwind.NTSB CHI94FA082Accident · 2 fatalField investigationFinal reportCessna A185F · Sterling Hgts, MIThe pilot's impairment of judgment and performance due to alcohol, which led to his intentional buzzing, and his failure to maintain sufficient altitude (or clearance) from obstacles. Factors related to the accident were: darkness and the unlighted tower.NTSB MIA94FA070Accident · 1 fatalField investigationFinal reportCessna 152 · Brooksville, FLThe pilot-in-command's failure to maintain a visual lookout and altitude while maneuvering after becoming lost/disoriented, resulting in an in-flight collision with trees and terrain. Contributing to the accident was the pilot's physical impairment due to…NTSB CHI94LA077Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Wichita, KSThe pilot's failure to attain the proper touchdown point and delay in aborting the landing. The pilot's inadequate training was a factor.NTSB SEA94FA055Accident · 2 fatalField investigationFinal reportBeech S35 · Ashland, ORPoor in-flight planning/decision. Factors to the accident were: clearance was not maintained and poor supervision.NTSB BFO94FA034Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Bethel, PAthe pilot attempting visual flight rules (VFR) flight into instrument meteorological conditions and the pilot not maintaining clearance from objects/terrain.NTSB MIA94FA058Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Pontotoc, MSThe pilot in command's failure to maintain altitude while manuevering resulting in the aircraft colliding with trees and then the ground.NTSB LAX94FA100Accident · 2 fatalField investigationFinal reportAerospatiale AS-350D · Lebec, CAThe pilot-in-command's inadequate in-flight planning and inadequate visual lookout. Factors in the accident were mountainous terrain which masked the presence of the wires and the pilot-in-command's lack of familiarity with the geographic area.NTSB SEA94LA047Accident · Minor injuriesLimited investigationFinal reportMBB BO-105S · Clearwater, ORThe pilot in command's failure to maintain clearance with the transmission wires. Factors contributing to the accident were the wires and sunglare.NTSB LAX94LA090Accident · 1 fatalLimited investigationFinal reportBell 206B · Coolidge Dam, AZthe pilot's selection of a cruise altitude insufficient to ensure adequate obstacle clearance and his inadequate visual lookout. A factor in the accident was the inconspicuousness of the power lines.NTSB LAX94LA092Accident · Minor injuriesLimited investigationFinal reportBeech 76 · Avalon, CAThe pilot's failure to see and avoid the powerlines. A related factor was the pilot's poor judgment in flying at low altitude.