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 CHI98LA238Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Strandquist, MNthe pilot's failure to maneuver to avoid obstructions. A factor was the trees.NTSB ATL98LA092Accident · 1 fatalLimited investigationFinal reportCessna 182 · Green Sea, SCThe inadvertent activation of the skydivers pilot chute, pulling him into the horizontal stabilizer/elevator, resulting in substantial damage to the airplane.NTSB SEA98LA155Accident · No injuriesLimited investigationFinal reportBurkhart Grob G102 · Douglas, WAThe pilot's failure to maintain clearance from objects on the ground. Factors include misjudgment of weather conditions (unfavorable winds).NTSB SEA98LA116Accident · Serious injuriesLimited investigationFinal reportCessna A150M · Langley, WAClearance from an object was not maintained. The pilot's lack of recent experience in the type of aircraft, improper use of carburetor heat and exceeding the gross weight of the airplane were factors.NTSB CHI98LA239Accident · Minor injuriesLimited investigationFinal reportRobinson R-44 · Cassville, MOThe pilot in command's inadequate preflight planning/preparation and weather evaluation that resulted in flight into adverse weather conditions. Factors to the accident were a preflight briefing service not being used and the transmission wire.NTSB FTW98FA290Accident · 1 fatalField investigationFinal reportCessna A188B · Panhandle, TXThe pilot's failure to maintain clearance from the power transmission wires while maneuvering during an aerial application flight.NTSB MIA98LA191Accident · No injuriesLimited investigationFinal reportCessna 152 · Columbia, SCThe pilot's delay in initiating a go-around, which resulted in an inflight collision with power lines.NTSB CHI98LA225Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Flushing, MIwas a delayed go-around maneuver by the pilot. Factors associated with this accident were the pilot misjudging his final approach altitude and glide path, having inadequate altitude to clear the trees at the end of the runway, and inadequate training on how…NTSB SEA98LA112Accident · No injuriesLimited investigationFinal reportAviat Husky A-1 · Triple R Ranch, MTThe pilot's misjudgment of distance and his failure to initiate a go-around. A factor was the high density altitude.NTSB NYC98LA135Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12-65 · West Buxton, MEfailure of the pilot to see-and-avoid power lines (inadequate visual lookout), as he was approaching to make a water landing on a river.NTSB FTW98GA286Accident · 2 fatalFinal reportLockheed SP-2H · Reserve, NMFailure of the copilot to maintain both lateral and vertical clearance from the trees, and failure of the captain to provide adequate supervision of the flight.NTSB FTW98FA287Accident · 1 fatalField investigationFinal reportCessna 175 · Clovis, NMThe pilot's failure to maintain adequate obstacle clearance and the proper landing glide path. Also causal was his loss of aircraft control during an attempted go-around. Factors were the dark night light conditions, the pilot's recent lack of sleep, and the…NTSB CHI98LA220Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Fargo, NDthe pilot's failure to maintain clearance with the powerline during a swath run. A factor associated with the accident was the powerline.NTSB CHI98LA219Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Mobridge, SDThe pilot's failure to maintain clearance from the power lines. Factors associated with the accident were the power lines, and the separation of the vertical stabilizer and rudder which resulted in the pilot's inability to maintain directional control of the…NTSB CHI98LA216Accident · Serious injuriesLimited investigationFinal reportPiper PA-36-375 · Stephen, MNthe visual lookout not being maintained by the pilot. A factor to the accident was the transmission wire.NTSB CHI98LA214Accident · No injuriesLimited investigationFinal reportCessna 188B · South Haven, MIthe pilot misjudging his distance and not maintaining the proper altitude. A factor was trees.NTSB CHI98LA208Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Winchester, MOThe pilot's low altitude flight and failure to maintain clearance, resulting in collision with trees. A factor was trees.NTSB ANC98LA104Accident · No injuriesLimited investigationFinal reportCessna 207 · Bethel, AKAn in-flight collision with a large bird.NTSB FTW98LA263Accident · 1 fatalLimited investigationFinal reportMoore B-8MJ · Pauls Valley, OKThe non-certificated pilot's failure to maintain clearance from the hangar. A factor was the pilot's maneuvering at a low altitude.NTSB ANC98LA073Accident · No injuriesLimited investigationFinal reportLake LA-4 · Saint Mary'S, AKThe pilot's diverted attention during takeoff, and his failure to maintain a proper climb rate. A factor associated with the accident was the presence of birds.NTSB LAX98LA198Accident · Minor injuriesLimited investigationFinal reportBoeing Stearman A75N1 · Riverbank, CAThe pilot's inadequate visual lookout for on-coming ground traffic.NTSB ATL98LA083Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Destin, FLThe pilot's failure to maintain directional control and her failure to maintain adequate obstacle clearance during an attempted go-around. A factor was the pilot's inadequate compensation for the crosswind conditions.NTSB SEA98LA095Accident · Serious injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Starbuck, WAThe pilot-in-command's failure to maintain adequate visual lookout. A contributing factor was the unmarked transmission lines.NTSB CHI98LA198Accident · Serious injuriesLimited investigationFinal reportBell 47G · Le Center, MNthe pilot's failure to maintain clearance with the wire. A factor associated with the accident was the wire which the helicopter contacted.NTSB SEA98FA084Accident · 1 fatalField investigationFinal reportMcDonnell Douglas 369FF · Shoshone, IDFailure to maintain clearance from wires. A transmission wire was a factor.NTSB MIA98FA172Accident · 1 fatalField investigationFinal reportAero Commander Callair A-9 · Ocean Springs, MSan in-flight collision with a nylon rope (wire), resulting in a loss of engine power, an inadvertent stall, and subsequent impact with the ground.NTSB FTW98LA250Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Balko, OKThe pilot's inadequate preflight planning which failed to assure adequate climb performance to clear an obstacle (fence) during takeoff climb.NTSB CHI98LA184Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7-15 · Waterloo, IAThe pilot's failure to maintain clearance with the power lines during climb. A factor was the power lines.NTSB FTW98LA247Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Claremore, OKThe pilot's failure to maintain obstacle clearance.NTSB FTW98FA238Accident · 1 fatalField investigationFinal reportBell 47G · Bixby, OKThe pilot's failure to maintain clearance from the power lines.NTSB CHI98LA173Accident · Serious injuriesLimited investigationFinal reportCessna 310R · Augusta, KSthe pilot's inadequate evaluation of the current local weather conditions and his failure to maintain a climb after takeoff. Factors related to the accident were the fog, the powerlines, and spatial disorientation.NTSB ANC98LA056Accident · No injuriesLimited investigationFinal reportCessna 207 · Quinhagak, AKThe pilot's failure to maintain directional control of the airplane, and his premature liftoff, resulting in a collision with a runway light fixture. Factors in the accident were wet runway conditions, and a rough and uneven runway surface with potholes.NTSB SEA98LA080Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-401 · Idaho Falls, IDThe pilot's failure to maintain clearance from a power transmission line during an aerial application flight. Factors include a power line located just beyond the boundary of the field being sprayed, and the pilot's incorrect judgement of the distance between…NTSB NYC98LA110Accident · 1 fatalLimited investigationFinal reportCessna 337B · Montgomery, NYthe pilot's improper decision to initiate a takeoff with the rear engine inoperative, which resulted in an airplane that could not climb sufficiently to clear obstacles (trees).NTSB FTW98LA225Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Parkin, ARthe pilot's improper planning/decision, which resulted in his failure to maintain sufficient altitude/clearance from trees at the departure end of the airstrip. Related factors were: high density altitude and trees at the departure end of the airstrip.NTSB CHI98LA155Accident · Serious injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Dawson, NDthe pilot's failure to maintain clearance with the telephone pole. Factors associated with the accident were the pole and the glare from the rising sun.NTSB FTW98LA217Accident · No injuriesLimited investigationFinal reportAyres SR2-T34 · Dewitt, ARThe pilot's failure to maintain proper clearance from a fixed obstacle [utility pole] while maneuvering. A factor was pilot fatigue.NTSB CHI98LA148Accident · Serious injuriesLimited investigationFinal reportCessna 150K · Clarkston, MIthe pilot selected unsuitable terrain on which to make the precautionary landing due to weather. Factors associated with the accident were the fog, low ceiling, poor in-flight planning, the precautionary landing, the loose wet gravel on which the…NTSB CHI98LA144Accident · Minor injuriesLimited investigationFinal reportCessna 170A · Emily, MNThe pilot's failure to maintain the proper rate of descent on final. A factor was the vegetation (bushes).NTSB FTW98IA208Incident · No injuriesIncident investigationFinal reportBoeing 727-25C · Colorado Sprngs, COAn inadvertent inflight collision with a flock of large birds.NTSB ATL98LA074Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Hendersonville, NCThe pilot's failure to attain the proper touchdown point and improper go-around procedures resulting in collision with wires, trees, and the ground. Factors were the pilot's lack of familiarity with the airplane and the short runway.NTSB MIA98LA150Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Woodstock, GAThe pilot's failure to establish a positive climb to outclimb obstacle (tree) and his decision to execute a takeoff with a tailwind.NTSB LAX98FA149Accident · 1 fatalField investigationFinal reportRobinson R22 · Irwindale, CAThe failure of the pilot to observe in a timely manner and maintain clearance from electrical power transmission wires and her improper maneuver to avoid the obstruction.NTSB NYC98LA104Accident · 2 fatalLimited investigationFinal reportHispano Aviacion HA200B Saeta · Xenia, OHThe pilot's failure to maintain altitude clearance with trees after an improper decision to perform low level aerobatics.NTSB ATL98LA068Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201T · Tampa, FLIn-flight collision with a bird, which separated a fuel line causing a loss of engine power, and resulting in an emergency landing on unsuitable terrain.NTSB CHI98LA134Accident · No injuriesLimited investigationFinal reportCessna 172 · Eagle River, WIthe pilot failed to compensate for the wind conditions, improperly executed a go-around when he raised the flaps, and failed to maintain obstacle clearance with the trees.NTSB MIA98LA138Accident · Minor injuriesLimited investigationFinal reportKaas Express · Lakeland, FLThe pilot's failure to maintain directional control during landing flare/touchdown.NTSB LAX98LA137Accident · No injuriesLimited investigationFinal reportGrumman American AA5B · Aguanga, CAthe lack of available published information regarding obstructions and nonstandard lighting at the private airport, and the lack of a lighted and properly marked displaced threshold.NTSB MIA98LA134Accident · No injuriesLimited investigationFinal reportAmerican Blimp A-1-50 · Quincy, FLThe pilot-in-command's and groundcrew chief's failure to properly evaluate wind conditions prior to attempting to moor the blimp.NTSB CHI98FA123Accident · 1 fatalField investigationFinal reportCessna 180J · Ashland, WIthe pilot failing to maintain separation from the trees. Factors contributing to this accident were the trees and the pilot being too low in altitude.