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 MIA97LA007Accident · No injuriesLimited investigationFinal reportCessna 172N · Fruitland Park, FLThe pilot's inadequate compensation for wind conditions and failure to maintain proper runway alignment during takeoff. The unfavorable wind condition was a related factor.NTSB FTW97LA019Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Throckmorton, TXfailure of the pilot to maintain clearance of a transmission wire during pullup from a swath run. The proximity of the transmission wire was a related factor. The installation of wire cutter equipment on the landing gear might have prevented or reduced the…NTSB IAD97LA006Accident · 1 fatalLimited investigationFinal reportPiper J3C-65 · Springfield, OHfailure of the pilot to maintain obstacle clearance, while maneuvering at low altitudes. A related factor was the quartering tail wind.NTSB SEA97FA005Accident · 1 fatalField investigationFinal reportCessna T210M · Everett, WAThe pilot's impairment of judgment and performance due to the recent excessive use of potent prescription drugs, the pilot's descent below the published decision height, and the pilot's failure to execute a missed approach. Factors contributing to the…NTSB MIA97LA004Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Ringgold, GAThe pilot's failure to see and avoid obstructions during takeoff.NTSB CHI97LA005Accident · Minor injuriesLimited investigationFinal reportBeech 23 · Neenah, WIthe local terrain conditions around the airport. A factor was the inadequate runway safety area.NTSB SEA96LA220Accident · No injuriesLimited investigationFinal reportRalph Taylor Royal T · Kent, WAin-flight collision with an unknown object.NTSB FTW96TA400Accident · No injuriesFinal reportCessna T188C · Snyder, TXThe pilot's failure to maintain clearance with a pole resulting in the separation of the left aileron and a loss of aircraft control. A factor was the haze.NTSB IAD96LA151Accident · 1 fatalLimited investigationFinal reportCessna 150C · Liberty, KYthe pilot's failure to maintain adequate altitude, while maneuvering at a low altitude, which resulted in in-flight collision with trees.NTSB CHI96LA349Accident · Serious injuriesLimited investigationFinal reportAvian Balloon Magnum IX · Stilwell, KSthe pilot's not maintaining adequate clearance from a tree, and his allowing an abrupt touchdown. Factors relating to the accident were: dusk and the proximity of tree(s).NTSB IAD96LA149Accident · No injuriesLimited investigationFinal reportCessna 172P · Richwood, WVimproper in-flight planning/decision by the flight crew, and inadequate supervision by the check pilot, which resulted in the flight crew's failure to maintain altitude/clearance from trees on rising terrain. A factor relating to the accident was:…NTSB ATL96LA130Accident · 1 fatalLimited investigationFinal reportAir Tractor 402 · Mayersville, MSthe pilot's misjudgment of his ground speed and distance to trees during the swath run, and his delayed pull-up at the end of the swath run, which resulted in his failure to remain clear of the trees. The tail wind and location of the trees were related…NTSB SEA96LA216Accident · 1 fatalLimited investigationFinal reportPiper PA-18 · Gillette, WYfailure of the pilot to see-and-avoid the obstruction (power line). The powerline was a related factor.NTSB ANC96LA155Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Skwentna, AKthe pilot's improper planning/decision. Related factors were: the terrain condition, unfavorable (lee-side) wind, and trees.NTSB SEA96TA213Accident · No injuriesFinal reportBell 206B-3 · St Regis, MTfailure of the pilot to maintain clearance from electrical transmission lines. The proximity of transmission lines was a related factor.NTSB LAX96LA330Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G102 · Warner Springs, CAimproper planning/decision by the pilot concerning a low altitude release to return to the airport after takeoff. Factors relating to the accident were: the pilot's inadequate preflight by failing to ensure that the yaw indicator string movement was free,…NTSB FTW97LA029Accident · No injuriesLimited investigationFinal reportPiper PA-36-300 · Stanton, TXPilot's failure to maintain clearance with a wire resulting in the separation of the rudder and a loss of aircraft control.NTSB FTW96LA379Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Palestine, TXThe pilot's selection of unsuitable terrain for takeoff.NTSB SEA96LA211Accident · No injuriesLimited investigationFinal reportCessna 172M · Pacific City, ORthe pilot's failure to see-and-avoid the transmission line. Factors relating to the accident were: the pilot's low altitude flight, and the transmission line.NTSB LAX96LA331Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Oxnard, CAthe instructor's inadequate supervision of the flight, and his delay in taking the controls and initiating a go-around. The student pilot's failure to maintain runway alignment and the proximity of the runway remaining marker were related factors.NTSB FTW96LA371Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Meadow, TXThe pilot's failure to maintain clearance from the transmission wire. A factor was the lack of suitable terrain for a forced landing.NTSB ANC96LA144Accident · No injuriesLimited investigationFinal reportCessna 207 · Kotzebue, AKan in-flight encouter with bird(s)/geese, which resulted in a bird strike.NTSB FTW96GA365Accident · 2 fatalFinal reportPiper PA-23-250 · Jennings, LAThe pilot's failure to maintain clearance. Factors were the pilot's lack of recent experience in the make and model of airplane, the dark night, and fog.NTSB FTW96LA361Accident · No injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Rio Rancho, NMthe pilot's failure to maintain clearance from the power lines. The variable wind condition was a related factor.NTSB CHI96LA313Accident · Serious injuriesLimited investigationFinal reportCessna A188B · Aitkin, MNthe pilot's failure to maintain clearance from known transmission lines. Factors relating to this accident were the transmission lines and the sunglare which hindered the pilot's ability to see the transmission lines.NTSB LAX96FA310Accident · 1 fatalField investigationFinal reportBell/Tsirah 209AH-1FT · Palmdale, CAthe first pilot misjudged the distance from the rock outcropping. The pilot's ostentatious display was a factor in this accident.NTSB FTW96FA352Accident · 2 fatalField investigationFinal reportGrumman American AA-1B · Boulder, COThe pilot's poor judgment in attempting low altitude flight in mountainous terrain without adequate mountain flying training which led to low altitude maneuvering exceeding the climb capability of the airplane. Factors in the accident were: the pilot's…NTSB CHI96LA310Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Galesburg, ILfailure of the pilot to maintain clearance from trees that protruded into the field that he was spraying.NTSB SEA96LA195Accident · No injuriesLimited investigationFinal reportCessna 182E · Grangeville, IDfailure of the pilot to maintain proper runway alignment and clearance from a fence post during landing. Factors relating to the accident were: an animal (deer) on the approach end of the runway, an encounter with a downdraft, and a fence post near the edge…NTSB ATL96LA121Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Tuscaloosa, ALThe pilot's failure to see and avoid an antenna during low altitude maneuvering.NTSB ANC96LA128Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Kenai, AKthe pilot's delayed in initiating a go-around, and his failure to maintain clearance from trees. The high/fast approach for landing was a related factor.NTSB CHI96LA300Accident · Serious injuriesLimited investigationFinal reportCessna 188 · Walnut Grove, MNthe pilot's failure to maintain proper clearance from the transmission wire.NTSB ANC96LA129Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Slana, AKThe pilot's failure to maintain directional control during takeoff. A factor associated with the accident was the rough and uneven terrain.NTSB CHI96LA294Accident · Serious injuriesLimited investigationFinal reportCameron CIGPACK-80 · Columbia, MOfailure of the pilot to see-and-avoid transmission (power) lines during the landing. Factors relating to the accident were: vegetation and trees, which obscured the pilot's view of the power lines.NTSB FTW96LA344Accident · 2 fatalLimited investigationFinal reportCessna TR182 · Port Isabel, TXpilot impairment of judgment and performance due to alcohol and drugs, and failure of the pilot(s) to maintain obstacle clearance, during an intentional low altitude flight manueuver (low pass under a bridge).NTSB MIA96LA210Accident · 1 fatalLimited investigationFinal reportBell 47G-4A · Adel, GAthe pilot's misjudgment of clearance between the helicopter and the antenna. A factor relating to the accident was the pilot's use of a drug (medication) that had sedative effects.NTSB LAX96LA304Accident · No injuriesLimited investigationFinal reportCessna 172N · Fullerton, CAthe pilot's misjudged glide path and delayed remedial action by not promptly initiating a go-around. A contributing factor was the pilot's lack of experience flying the airplane.NTSB CHI96LA288Accident · No injuriesLimited investigationFinal reportBeech 23 · Wilmot, WIimproper planning/decision by the flight instructor (CFI) by failing to ensure that the airplane would be able to clear brush and trees near the departure end of the runway.NTSB CHI96LA277Accident · No injuriesLimited investigationFinal reportWeatherly 201B · Fargo, NDthe pilot's failure to maintain clearance from a wire, while crossing under a transmission line. The proximity of wires to the work area was a related factor.NTSB SEA96LA180Accident · No injuriesLimited investigationFinal reportGrumman American AA-5A · Klamath Falls, ORthe pilot's inadequate compensation for wind conditions, and his failure to maintain proper alignment with the runway during the landing/go-around. Factors relating to the accident were: strong, gusty crosswinds, and the encounter with a runway…NTSB MIA96LA200Accident · 1 fatalLimited investigationFinal reportBell 206B III · Barton, ALfailure of the pilot to see-and/or-avoid the obstruction (unmarked power line), while en route between the area that was being treated and the refueling location. The power line and lack of visual cues at dusk were related factors.NTSB CHI96LA279Accident · No injuriesLimited investigationFinal reportSchleicher ASK-13 · Thompsonville, MIan evasive maneuver necessitated by the tow plane's aborted takeoff.NTSB CHI96LA266Accident · Serious injuriesLimited investigationFinal reportCessna 404 · Benton Harbor, MIthe pilot's delay in initiating a go-around after not attaining the proper touchdown point during the landing, and his failure to remain clear of obstructions (trees) during the go-around. Factors relating to the accident were the adverse weather condition…NTSB ATL96LA116Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Mayersville, MSfailure of the pilot to maintain adequate clearance from an object (vehicle) on the ground.NTSB SEA96LA169Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Nez Perce, IDthe pilot's improper in-flight decision to turn up a canyon, which the aircraft was unable to out-climb. Factors relating to the accident were: high ambient temperature, high density altitude, blind/box canyon, and trees in the area where the aircraft's climb…NTSB SEA96LA167Accident · Serious injuriesLimited investigationFinal reportPiper PA-25-235 · Cornelius, ORthe pilot's inadequate preflight planning, and his failure to see-and-avoid the obstruction (inadequate visual lookout). The transmission wire was a related factor.NTSB SEA96LA166Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Kettle Falls, WAthe pilot's inadequate preflight planning. Factors relating to the accident were: high ambient temperatures; departing from a short, grass runway; and tall trees off the departure end of the airstrip.NTSB LAX96FA290Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Mound House, NVthe flight instructor's improper in-flight planning/decision by allowing the student pilot to get too low during a simulated emergency landing before initiating a go-around.NTSB IAD96LA122Accident · 1 fatalLimited investigationFinal reportCessna 150L · Philippi, WVthe pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his failure to maintain sufficient altitude/clearance from trees, while maneuvering at low altitude. Intentional maneuvering at low altitude was a…NTSB SEA96LA163Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Stehekin, WAthe pilot's improper planning/decision, and his failure to ensure that the airplane would remain clear of trees during the takeoff. Factors relating to the accident were: high density altitude, and the proximity of trees to the runway.