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 SEA98LA009Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Midvale, IDThe student pilot's failure to maintain adequate clearance with the pole. A factor contributing to the accident was the pole.NTSB FTW98FA028Accident · 1 fatalField investigationFinal reportWeatherly 620B · Cee Vee, TXThe pilot's failure to maintain clearance with the power lines during an aerial application flight.NTSB ATL98LA004Accident · No injuriesLimited investigationFinal reportPiper PA-25-235C · Blakley, GAthe pilot misjudge clearance from trees during pull-up from a swath run. The obstructions (power line and trees) were related factors.NTSB LAX98LA017Accident · No injuriesLimited investigationFinal reportSchweizer 126-D · Peoria, AZThe pilot's failure to maintain an adequate clearance from obstacles during the landing approach.NTSB SEA98LA003Accident · Minor injuriesLimited investigationFinal reportChampion 7EC · Galata, MTThe pilot's failure to adequately perform preflight planning (prior to the precautionary landing and prior to the subsequent takeoff), his selection of an unsuitable takeoff area, and his failure to maintain altitude/clearance from the fence during the…NTSB LAX98FA013Accident · No injuriesField investigationFinal reportBeech 99-C99 · Meadview, AZThe pilot's inadequate in-flight decision, inadequate visual lookout, and his failure to maintain adequate obstacle clearance. Contributing was low altitude flight.NTSB CHI98LA021Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Grand Forks, NDthe pilot's inadequate preflight planning which resulted in a low fuel state, and his inability to see the wire which the helicopter contacted. Factors associated to the accident were the precautionary landing, the dark night conditions, and the wire which…NTSB ANC98LA003Accident · No injuriesLimited investigationFinal reportBell 206-B2 · Sutton, AKThe pilot's failure to maintain clearance between the tail rotor and the external long line cable, and the subsequent entanglement of the tail rotor with the long line.NTSB NYC98LA012Accident · No injuriesLimited investigationFinal reportCessna 172P · Pittsfield, MAThe pilot's poor in-flight decision to continue VFR flight in IFR conditions. Factor's in this accident were the pilot's inadequate pre-flight planning, and fog.NTSB FTW98FA012Accident · 1 fatalField investigationFinal reportCessna A188B · Morton, TXThe pilot's failure to maintain clearance from the power lines while maneuvering during an aerial application flight.NTSB LAX98FA009Accident · 1 fatalField investigationFinal reportBellanca 7ECA · Tracy, CAThe pilot's low operating altitude and his failure to maintain appropriate clearance during low level maneuvering flight. Contributing factors were transmission wires and the physical impairment that resulted from the effects of the over-the-counter…NTSB ATL98LA001Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Sylvania, GAThe pilots failure to maintain clearance from transmission wires.NTSB FTW98LA143Accident · No injuriesLimited investigationFinal reportAerostar S-60A · Albuquerque, NMthe pilot's failure to maintain control of the balloon.NTSB FTW98LA006Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Plains, TXThe pilot's improper decision to initiate takeoff with a vehicle on the runway.NTSB IAD97LA124Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Zanesville, OHThe pilot's failure to perform the published short/soft field takeoff procedures.NTSB CHI97LA304Accident · 1 fatalLimited investigationFinal reportLuscombe 8A · Brooklyn, MIfailure of the pilot to see-and-avoid the transmission wires (inadequate visual lookout, and failing to maintain sufficient altitude and clearance from the obstruction).NTSB SEA97IA217Incident · No injuriesIncident investigationFinal reportPiper PA-23-250 · Soda Springs, IDThe pilot's failure to see-and-avoid the truck. Related factors included: a truck, insufficient runway obstruction information provided in the Airport/Facility Directory by the FAA, and VASI glide path angle setting (by local airport personnel) which provided…NTSB ANC97LA154Accident · No injuriesLimited investigationFinal reportCessna 170B · Lime Village, AKThe pilot's selection of unsuitable terrain for takeoff.NTSB FTW97LA354Accident · Minor injuriesLimited investigationFinal reportBell 206L-3 · Houma, LAThe loss of aircraft control resulting from a bird strike that severed the cyclic flight control.NTSB MIA97FA248Accident · 2 fatalField investigationFinal reportBell 47G · Saluda, SCin-flight collision with a tree, for undetermined reason(s).NTSB SEA97LA212Accident · 2 fatalLimited investigationFinal reportBellanca 7KCAB · Oakridge, ORThe first pilot's decision to perform a low altitude maneuver, and his subsequent failure to maintain altitude and clearance from trees during a low altitude maneuver.NTSB FTW97FA345Accident · 1 fatalField investigationFinal reportPiper PA-18-150 · Ethel, LAThe pilot's failure to maintain clearance. Related factors were the pilot's impairment due to alcohol and night conditions.NTSB FTW97LA347Accident · No injuriesLimited investigationFinal reportHughes MDL-369HS · Brinkley, ARThe in flight collision of the tail rotor blade with an object that had a brass zipper on it, and the subsequent overload and failure of the tail rotor drive shaft. Factors were the object with the brass zipper on it and the unsuitable terrain for the forced…NTSB SEA97LA208Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Columbus, MTthe pilot passenger failed to maintain clearance from the power line.NTSB SEA97FA206Accident · 1 fatalField investigationFinal reportPiper PA-12 · Horseshoe Bend, IDthe pilot's failure to maintain clearance from transmission wires. The wires were a factor.NTSB SEA97LA203Accident · 1 fatalLimited investigationFinal reportPiper PA-18-150 · Harrah, WAThe pilot's failure to maintain clearance from a transmission wire while on final approach. A factor was a 40-foot high transmission wire located approximately 20 feet from the end of the airstrip.NTSB ATL97LA133Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Kenly, NCThe pilot's failure to see and avoid a utility line on final approach to land. The sunglare and utility line were factors.NTSB CHI97LA278Accident · 1 fatalLimited investigationFinal reportSchweizer G-164B · Larimore, NDthe pilot delaying the swath run turnaround maneuver at the end of the field boundary, and his failure to maintain clearance between the airplane and the high tension wires. A factor was the pilot's inattentiveness regarding the time to begin the swath run…NTSB CHI97LA279Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Castlewood, SDThe pilot's failure to maintain adequate clearance from the trees.NTSB IAD97LA115Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Gardiner, NYThe pilot's failure to initiate a go-around. A related factor is the pilot's misjudgment of speed and altitude.NTSB FTW97LA336Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Muleshoe, TXfailure of the pilot to see the standpipe in time to avoid an accident (inadequate visual lookout), and his failure to maintain clearance with electrical wires, while maneuvering during an aerial application flight.NTSB NYC97FA173Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Hancock, MAThe pilot's failure to maintain adequate terrain clearance and the proper altitude. Contributing was mountainous terrain.NTSB MIA97IA237Incident · Minor injuriesIncident investigationFinal reportBoeing 737-300 · Tampa, FLin-flight collision with a bird.NTSB FTW97LA317Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Vernon, TXfailure of the pilot to maintain clearance from an irrigation pipe. Factors relating to the accident were: the poor light condition at dusk, the object (vertical piece of irragation pipe), loss of engine power from foreign object damage, and the lack of…NTSB MIA97LA234Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Siler City, NCFailure of the pilot to obtain a preflight weather briefing, inaccurate weather evaluation by the pilot, and his poor in-flight planning decision for descending too low to read a road sign.NTSB CHI97LA263Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Burlington, WIthe deer which contacted the airplane.NTSB LAX97FA288Accident · 1 fatalField investigationFinal reportTaylorcraft BC12-D · Corcoran, CAThe pilot's failure to maintain separation from ground obstacles.NTSB LAX97LA287Accident · Serious injuriesLimited investigationFinal reportAerostar S-55A · Marana, AZThe pilot's in-flight planning/decision to continue his flight after striking a fence, and his inability to attain the proper climb rate, which subsequently led to the in-flight collision with the transmission power line.NTSB ATL97LA121Accident · No injuriesLimited investigationFinal reportBell 47-D1 · Holcomb, MSThe failure of the pilot to adequately see and avoid all obstructions while doing aerial application work.NTSB SEA97FA181Accident · 1 fatalField investigationFinal reportAvian Magnum IX · Donald, ORThe pilot's failure to maintain clearance from a tree that was located on the edge of the field in which he was attempting to land.NTSB CHI97LA251Accident · Serious injuriesLimited investigationFinal reportLarsen T-BIRD II · Oshkosh, WIthe pilot's failure to maintain flying speed and loss of control resulting in a stall. Factors were the tree and the fence.NTSB CHI97LA236Accident · No injuriesLimited investigationFinal reportCessna 150M · Lee'S Summit, MOthe pilot's inadequate preflight planning/preparation, and his failure to ensure that the airplane remained clear of obstrictions (trees). Factors associated with the accident were: the short runway/takeoff area, and the proximity of trees.NTSB MIA97LA221Accident · No injuriesLimited investigationFinal reportCessna 188 · Benson, NCThe pilot's failure to maintain a visual lookout during a swath run resulting in an in-flight collision with a cable, subsequent loss of engine power, forced landing, and an in-flight collision with terrain. Contributing to the accident was a total loss of…NTSB FTW97FA285Accident · 1 fatalField investigationFinal reportAyres S2R-T15 · Oakridge, LAThe pilot's failure to maintain clearance for undetermined reasons.NTSB CHI97LA230Accident · Minor injuriesLimited investigationFinal reportJenkins RV-6 · Middleton, WIthe pilot was too low on final approach and hit the high vegetation.NTSB CHI97LA228Accident · No injuriesLimited investigationFinal reportCessna 188B · Halstead, KSthe pilot failed to maintain adequate clearance from the transmission wires. Factors included the malfunctioning of the wire cutter and pilot fatigue.NTSB CHI97LA227Accident · Minor injuriesLimited investigationFinal reportKearns RV-6 · Harrisburg, ILThe pilot's failure to maintain adequate clearance. A factor was the marked transmission wire.NTSB SEA97LA177Accident · 2 fatalLimited investigationFinal reportCessna 182G · Big Creek, IDThe flightcrew's failure to maintain clearance from trees. A factor was trees north of the departure end of the airstrip.NTSB MIA97LA212Accident · Minor injuriesLimited investigationFinal reportContinental Copters MK5A · Sylacauga, ALThe failure of the pilot to maintain main rotor rpm resulting in the helicopter descending and colliding with trees.NTSB ATL97LA110Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Portland, TNThe pilot's attempt to perform a short field takeoff in unsuitable terrain. A related factor was the pilot's desire to impress his co-workers.