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 ATL00LA074Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Clarksville, TNThe pilot's failure to follow published instrument approach procedures, and collided with a tree while executing a missed approach. Factors were low clouds, fog and a tree.NTSB LAX00LA285Accident · 1 fatalLimited investigationFinal reportGrumman G-164B · Tracy, CAThe pilot's failure to maintain adequate clearance from obstacles while maneuvering during an aerial application flight.NTSB SEA00LA148Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-301 · Brockway, MTThe pilot's failure to maintain clearance from power lines.NTSB SEA00LA162Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Birkenfeld, ORThe pilot's delayed go-around, which resulted in the aircraft not clearing the fence posts. A contributing factor was the fence posts.NTSB LAX00LA280Accident · No injuriesLimited investigationFinal reportBell 47G-5 · King City, CAThe pilot's intentional flight into adverse weather which resulted in loss of visual reference and flight into power transmission wires and terrain.NTSB FTW00LA217Accident · Serious injuriesLimited investigationFinal reportCessna 172B · Olney, TXThe pilot's inadequate compensation for wind conditions. A factor was the gusty crosswind.NTSB IAD00LA065Accident · Serious injuriesLimited investigationFinal reportRotorway Exec 90 · Circleville, OHPilot's improper decision to depart a confined area with two people onboard, which resulted in a loss of rotor RPM and collision with a utility pole and wires.NTSB SEA00LA137Accident · No injuriesLimited investigationFinal reportBeaver Ferguson F-II · Benton City, WAThe pilot's failure to approach the strip with adequate airspeed for the conditions (resulting in a stall/mush situation), and his failure to maintain adequate altitude and/or clearance above a power line on the approach path. Factors included crosswind…NTSB MIA00LA226Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Statesboro, GAThe pilots failure to calculate his takeoff distance for the conditions, resulting in an in-flight collision with a fence, trees, and the terrain. A factor in the accident is the FAA's failure to require of the manufacturer and the manufacturer's failure to…NTSB CHI00LA206Accident · 1 fatalLimited investigationFinal reportMead Kolb Firestar II · Gwinn, MIthe pilot not obtaining/maintaining altitude/clearance. Factors were the tree and the high density altitude.NTSB FTW00LA206Accident · No injuriesLimited investigationFinal reportMbb BK-117-A3 · Allen, TXthe pilot's failure to maintain obstacle clearance while hovering the helicopter. A contributing factor was the dark night light conditions.NTSB LAX00LA267Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-160 · Lancaster, CAThe pilot's inadequate compensation for gusty winds conditions that resulted in the collision with a power line during final approach.NTSB CHI00FA200Accident · 1 fatalField investigationFinal reportBeech 35 · Columbus, NEthe failure of the pilot to maintain clearance from the power line. Factors were the sunglare and the wire.NTSB FTW00LA213Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Stephenville, TXThe collision with a bird while in cruise flight.NTSB SEA00FA133Accident · 3 fatalField investigationFinal reportCessna 150E · Ashton, IDThe pilot's failure to maintain clearance from a tree while making a low pass over an outdoor gathering of individuals. Factors include the intentional low pass, a tree located in a shadow generated by the sun's low position at dusk, hilly terrain, and the…NTSB NYC00LA197Accident · Serious injuriesLimited investigationFinal reportFairchild M-62C · Carthage, NYthe pilot's improper decision to depart with obstacles ahead which exceeded the climb capability of the airplane. Factors were the grass runway, and trees at the departure end of the runway.NTSB SEA00LA131Accident · Minor injuriesLimited investigationFinal reportWsk Pzl Mielec M-18 Dromader · Burley, IDImproper airstrip operations by ground personnel, and the pilot's failure to visually detect a vehicle on the airstrip in time to avoid a collision. Factors included a vehicle on the airstrip, tailwind conditions, and high density altitude conditions.NTSB CHI00LA210Accident · No injuriesLimited investigationFinal reportGrumman G164 · Mcville, NDthe pilot's failure to maintain clearance with the power lines. A factor associated with the accident was the power line.NTSB NYC00LA186Accident · No injuriesLimited investigationFinal reportHelfer Flightstar II · Greenland, NHThe pilot-in-command's improper decision to takeoff uphill, on a short runway with 50-foot high utility wires at the end, at a high gross weight. Factors were the high weight and uphill terrain.NTSB FTW00LA199Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Chase, LAThe failure of the pilot to maintain clearance with the deer stand. Factors were the chemical covering the windshield and the glare from the setting sun.NTSB DEN00LA124Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Logan, UTin-flight collision with a jacket, which blew out of the helicopter because the left passenger door was not properly secured prior to takeoff. A contributing factor was the pilot's failure to ensure the door was properly closed prior to takeoff.NTSB ANC00LA085Accident · No injuriesLimited investigationFinal reportCessna 207 · Anaktuvuk Pass, AKThe pilot's selection of an unsuitable landing area. Factors associated with the accident were a fuel drum, and a tailwind.NTSB FTW00LA195Accident · Minor injuriesLimited investigationFinal reportAyres S2R-T34 · Anahuac, TXThe pilot's failure to maintain clearance with the power line. A factor was the lack of suitable terrain for the forced landing.NTSB LAX00LA250Accident · Serious injuriesLimited investigationFinal reportThorp T211 · Grass Valley, CAthe pilot encountered a mountain wave at an altitude too low to maintain clearance from trees.NTSB FTW00LA192Accident · Minor injuriesLimited investigationFinal reportAyres S2R-G10 · Brownfield, TXThe loss of engine power due to the blocked engine intake, which resulted from ingesting birds. Factors were the lack of suitable terrain for the forced landing and the pilot's intentional ground loop in an attempt to avoid a ditch.NTSB MIA00LA205Accident · No injuriesLimited investigationFinal reportBeech 65-A90 · Lake Wales, FLThe pilot's inadequate visual lookout while maneuvering to avoid a flock of birds shortly after takeoff, resulting in the aircraft colliding with a wire. A factor in the accident was the pilot's fatigue after having worked everyday for the previous 3 weeks.NTSB MIA00LA195Accident · No injuriesLimited investigationFinal reportCessna 402C · Naples, FLan inflight collision with a bird during descent that resulted in substantial damage to the airplane's vertical stabilizer spar.NTSB DEN00FA119Accident · 2 fatalField investigationFinal reportCessna 172H · Angel Fire, NMThe pilot's improper inflight decision to prematurely attempt a climb towards rising terrain before sufficient altitude had been attained that would assure adequate obstacle clearance. Factors were high density altitude and trees.NTSB DEN00LA116Accident · No injuriesLimited investigationFinal reportCessna 310C · Erie, COA sudden and unexpected encounter with a downdraft while on final approach. A factor was the transmission wire.NTSB IAD00FA053Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Bealeton, VAthe flight instructor's improper pre-flight plan and decision to land and depart an airport with insufficient runway. A factor in the accident was the short grass runway with a 100-foot obstruction at the end.NTSB SEA00LA113Accident · No injuriesLimited investigationFinal reportCessna 172M · Wallace, IDThe pilot's failure to maintain airspeed and his failure to maintain clearance from the trees. Related factors were trees and mountainous terrain.NTSB NYC00LA171Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Ventus 2CM · Warren, VTThe pilot's inadequate compensation for crosswind conditions. A factor in the accident was the cross wind.NTSB LAX00LA233Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Coleville, CAthe tow plane pilot's inadequate airplane performance calculations.NTSB LAX00LA232Accident · No injuriesLimited investigationFinal reportSchleicher AS20 · Coleville, CAthe tow plane pilot's inadequate airplane performance calculations.NTSB SEA00LA105Accident · No injuriesLimited investigationFinal reportSchmidt SEA REY · Northport, WAThe pilot's loss of directional control due to his inadequate remedial action in correcting for engine torque during the aborted landing. Factors include trees near the area where the pilot was attempting to land.NTSB FTW00LA179Accident · 1 fatalLimited investigationFinal reportAyres S2R-T34 · Helena, ARThe pilot's failure to maintain clearance with the power lines.NTSB DEN00LA108Accident · No injuriesLimited investigationFinal reportPiper PA-44-180T · Englewood, COFailure of the instructor pilot-in-command and the pilot receiving instruction to maintain directional control. Factors were the pilot receiving instruction allowing the airplane to approach low and slow, and failure of the instructor to maintain adequate…NTSB DEN00LA106Accident · No injuriesLimited investigationFinal reportCessna 170B · Dutch John, UTThe pilot's failure to maintain clearance with the trees. Factors were a high-density altitude and wind gusts.NTSB CHI00LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Sully, IAThe pilot inadvertently applied full flaps during the aborted landing and was not able to gain enough altitude to clear a fence post at the end of the airstrip. Factors associated with the accident were the trees at the approach end of the airstrip, the pilot…NTSB ATL00LA060Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Foley, ALThe pilot exceeding the performance capability of the airplane during takeoff. A factor was the trees.NTSB SEA00LA099Accident · Serious injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Colfax, WAThe pilots failure to maintain clearance from power transmission lines.NTSB ATL00LA059Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Indiantown, FLThe student pilot's failure to maintain altitude clearance during initial climb following takeoff during the commission of a crime, resulting in an in-flight collision with a tree.NTSB NYC00LA149Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Miamisburg, OHThe CFI's delayed remedial action.NTSB IAD00LA051Accident · No injuriesLimited investigationFinal reportSlingsby 41-2 · Dansville, NYThe pilot's failure to retract the speed brakes which resulted in not obtaining the proper touch down point. A factor to the accident was the pilot's lack of experience in the make and model glider.NTSB FTW00LA162Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-401B · Thibodaux, LAThe pilot's failure to maintain clearance with the power lines while maneuvering during an aerial application flight. A factor was the sunglare on the windscreen.NTSB MIA00LA180Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Stockbridge, GAan in-flight collision with trees while maneuvering, which was the result of the pilot not allowing adequate altitude to clear the trees before starting a turn.NTSB SEA00LA093Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Johnson Creek, IDThe pilot's failure to maintain clearance from the rising terrain. Factors include his poor decision to depart without assurance that he could clear the surrounding terrain under the ambient conditions, his failure to adhere to the accepted procedure of…NTSB CHI00FA145Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Taylor, MOflight into known adverse weather conditions and the altitude/clearance not maintained by the pilot. An additional cause was the improper in-flight planning/decision by the pilot. Contributing factors were the weather below approach/landing minimums, night…NTSB LAX00FA206Accident · 2 fatalField investigationFinal reportBeech F33A · Columbia, CAThe pilot's failure to abort the downwind takeoff and his failure to attain flying speed.NTSB SEA00LA092Accident · Serious injuriesLimited investigationFinal reportSikorsky S-58 · Buhl, IDThe pilot's inadequate visual lookout, and his failure to maintain adequate clearance from the power lines. The pilot's diverted attention, a dirty windshield, power lines, and light rain were factors.