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 LAX96LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA-22 · Battle Mountain, NVthe pilot's failure to see and avoid utility transmission wires suspended across the final approach flight path.NTSB FTW96LA022Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Tahoka, TXthe pilot's failure to maintain clearance from wires. Factors were the loss of aileron control and the lack of suitable terrain for a forced landing.NTSB MIA96LA006Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Eastman, GAThe failure of the pilot-in-command to perform fuel consumption calculations, and the decision not to refuel. Contributing to the accident was fuel exhaustion, and the pilot- in-command's decision to operate the airplane with the fuel gauges inoperative.NTSB NYC96LA006Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Honeoye Falls, NYthe pilot's failure to establish a climb in that he failed to raise the flaps and failed to assure full power was applied during the go-around.NTSB FTW96FA012Accident · 3 fatalField investigationFinal reportCessna 172RG · Bayfield, COThe pilot's failure to maintain adequate terrain clearance. A factor was the pilot diverting attention while looking for game.NTSB BFO96FA010Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Bird-In-Hand, PAthe pilot's (PIC's) improper in-flight planning/decision concerning simulated instrument flight during the traffic pattern/descent; and failure of the safety pilot (other crewmember) to provide adequate visual lookout to see-and-avoid the obstruction.NTSB BFO96LA003Accident · No injuriesLimited investigationFinal reportEnstrom F28-280C · Blue Ash, OHthe commercial pilot's failure to maintain clearance from obstacles during hover-taxi operations. Related factors the tailwind, the nearby obstacle, and the misjudged maneuver to avoid obstacles.NTSB ANC96LA002Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Healy, AKA failure of the pilot to adequately compensate for crosswind conditions. A factor in the accident was a crosswind.NTSB FTW96LA008Accident · Minor injuriesLimited investigationFinal reportBell 47-G2 · Freer, TXthe pilot's failure to maintain clearance from the power lines due to his improper takeoff technique. A factor was the helicopter induced blowing dust which impaired the pilot's visibility.NTSB ATL96LA001Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Savannah, GAThe pilot's selection of unsuitable terrain for a precautionary landing, and his failure to maintain clearance from an obstacle (road sign) during the landing.NTSB FTW95FA407Accident · 1 fatalField investigationFinal reportBeech A36 · Brady, TXthe pilot's improper decision to attempt a night landing without the visual cues necessary to establish runway alignment. Factors were the dark night light condition, the inoperative runway edge lights, and the failure of airport management to issue a NOTAM…NTSB ATL95FA174Accident · 2 fatalField investigationFinal reportPiper PA-44-180 · Columbia, SCthe pilot's improper IFR procedure by allowing the airplane to descend below the ILS glideslope and by continued descent below the decision height. Factors relating to the accident were: darkness, low ceiling, and fog.NTSB FTW95LA404Accident · 1 fatalLimited investigationFinal reportFratus XP-23 Hawk · Joshua, TXthe pilot's failure to see and avoid the wires.NTSB NYC95LA225Accident · 2 fatalLimited investigationFinal reportSnyded Pitts S1E · Somers, NYThe pilot's inadequate visual lookout, which resulted his failure to see-and-avoid the power line.NTSB MIA95FA226Accident · Serious injuriesField investigationFinal reportMitsubishi MU-2B-35 · Smyrna, TNFailure of the pilot to maintain a proper climb rate after takeoff, and his inadvertent entry in a descending spiral, which he failed to correct. Factors relating to the accident were: darkness, and the pilot becoming spatially disoriented during the initial…NTSB LAX95LA348Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Marana, AZthe pilot misjudged clearance from the power lines.NTSB CHI95LA341Accident · No injuriesLimited investigationFinal reportSwearingen SA-226TC · South Bend, INthe Pilot-in-Command's inadequate supervision of the flight and failure to assure that proper airspeed, rate of climb, and clearance from trees were obtained/maintained.NTSB CHI95LA324Accident · No injuriesLimited investigationFinal reportCessna 177 · Camp Lake, WIthe pilot's inadequate compensation for wind conditions, and failure to maintain altitude/clearance from the power line, while on short final approach. The downdraft was a related factor.NTSB MIA95LA221Accident · Serious injuriesLimited investigationFinal reportBeech 77 · Hendersonville, NCThe failure of the pilot-in-command to perform preflight weight and balance calculations resulting in the airplane exceeding the maximum gross takeoff weight limitations.NTSB FTW95FA393Accident · 3 fatalField investigationFinal reportCessna 172M · Witter, ARfailure of the pilot to maintain sufficient altitude/clearance from high/wooded terrain. Factors relating to the accident were: darkness, high terrain, and foggy weather conditions. Also, the pilot's use of Methamphetamine (not approved by the FAA) was a…NTSB MIA95LA219Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1 · Sarasota, FLThe pilot's failure to abort the takeoff resulting in a premature takeoff, and subsequent in-flight collision with terrain. The pilot's failure to perform the necessary performance data computations for the flight and his diverted attention due to…NTSB FTW95LA387Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Cibolo, TXThe pilot's improper planning/decision and failure to abort the takeoff, while there was sufficient runway remaining.NTSB ANC95LA161Accident · No injuriesLimited investigationFinal reportMaule M-7 · Aniak, AKThe pilot's selection of unsuitable terrain for takeoff.NTSB SEA95LA210Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Castle Rock, WAsabotage by a hunter (shooting at the helicopter with a crossbow).NTSB FTW95LA379Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Loop, TXThe pilot's failure to maintain clearance with the power line. A factor was the sun glare light conditions.NTSB CHI95LA308Accident · No injuriesLimited investigationFinal reportLet L-23 Super Blanik · White Bear Lake, MNthe pilot's delayed retraction of the spoilers. Factors were the excessive sink rate and the power lines.NTSB SEA95FA198Accident · 1 fatalField investigationFinal reportBeech A24R · Yakima, WAThe pilot's failure to maintain clearance from a tree. Factors related to the accident were: the pilot's poor judgment and ostentatious display to buzz.NTSB NYC95LA215Accident · Minor injuriesLimited investigationFinal reportSchleicher KA-8B · Mayville, NYThe pilot's inadequate inflight planning, which resulted in an inflight collision with trees.NTSB LAX95FA313Accident · 2 fatalField investigationFinal reportBell 206-L1 · Johnsondale, CAthe pilot's failure to maintain an adequate obstacle clearance altitude while operating at a very low level. The aircraft's lack of wire cutters was a factor in this accident.NTSB NYC95LA207Accident · 1 fatalLimited investigationFinal reportCessna 172M · Kingswood Twsp, NJFailure of the pilot to maintain control of the airplane, which resulted in an in-flight collision with trees.NTSB FTW95FA363Accident · Serious injuriesField investigationFinal reportPiper PA-32R-300 · Wichita Falls, TXthe pilot's failure to maintain airspeed while diverting attention to an open cargo door. A factor was the pilot's inadequate preflight inspection.NTSB BFO95LA088Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Put-In-Bay, OHThe pilot's delay in aborting the landing after selecting the wrong runway. Factors relating to the accident were: garbled radio transmissions on the UNICOM frequency, and the resultant tailwind for landing.NTSB ANC95LA149Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Soldotna, AKThe pilot's improper in-flight planning/decision, and his failure to maintain sufficient altitude to assure clearance from obstructions. The downdraft was a related factor.NTSB SEA95LA191Accident · No injuriesLimited investigationFinal reportSchweizer G-164 · Nyssa, ORthe pilot's inadequate ground reconnaissance.NTSB LAX95TA304Accident · No injuriesFinal reportDouglas C-54G · Aubeery, CAfailure of the pilot to see and avoid known obstacles along his route of flight. Contributing was the insufficient information given by the pilot in the lead aircraft.NTSB FTW95LA358Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Taft, TXThe pilot's diverted attention, which resulted in his failure to assure that clearance was maintained from the transmission line.NTSB FTW95LA356Accident · No injuriesLimited investigationFinal reportEnstrom 280C · Houston, TXThe flight instructor's poor judgement, and his disregard of the owner's objection to air taxi into the hangar.NTSB FTW95LA357Accident · No injuriesLimited investigationFinal reportCessna 152 · Bristow, OKThe pilot's failure to maintain clearance. A factor was the fence at the end of the airstrip.NTSB LAX95LA298Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas 500 · Pacific Ocean (Pacific Ocean)the accidental discharge of a spear gun by the observer.NTSB NYC95LA196Accident · Serious injuriesLimited investigationFinal reportCessna 150 · North East, PAThe student pilot's delay in initiating an aborted landing and his failure to attain obstacle clearance.NTSB ANC95LA139Accident · Serious injuriesLimited investigationFinal reportMaule MA-4 · Port Alsworth, AKThe pilot's improper planning/decision and failure to attain sufficient airspeed to sustain a climb before hitting trees. The unfavorable wind condition was a related factor.NTSB NYC95LA189Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Erwinna, PAthe flight instructor's inadequate supervision during the final approach which resulted in the student flying a low approach and a subsequent collision with the trees. A factor relating to the accident was the student pilot's failure to maintain a proper…NTSB MIA95LA204Accident · 1 fatalLimited investigationFinal reportCessna A188B · Muscle Shoals, ALFailure of the pilot to maintain adequate visual lookout to see-and-avoid electrical power lines, while approaching a field for aerial application.NTSB BFO95LA085Accident · Serious injuriesLimited investigationFinal reportBirdman Enterprises Chinook 2S · Hammondsville, OHthe pilot's failure to maintain adequate altitude/clearance from obstacles (power lines) in his flight path.NTSB ATL95LA156Accident · Serious injuriesLimited investigationFinal reportBeech A36 · Mckenzie, TNThe pilot's failure to comply with the performance data for the aircraft in his attempt to takeoff, downwind, from the short sod runway, with high density altitude, and with the aircraft weight in excess of the maximum gross weight allowed.NTSB ATL95LA155Accident · No injuriesLimited investigationFinal reportSchweizer 233A · Louisburg, NCThe flight instructor's improper in-flight planning and decision, in that he failed to maintain sufficient altitude to clear the trees surrounding the airport, and failed to take into consideration the high density altitude at the time of the accident.NTSB FTW95LA347Accident · No injuriesLimited investigationFinal reportAyres S2R-T34 · Lake City, ARThe pilot's failure to maintain clearance with the transmission wires.NTSB BFO95LA077Accident · Serious injuriesLimited investigationFinal reportBeech 35 · Paintersville, OHThe pilot's continued VFR flight into instrument meteorological conditions. Factors related to the accident were: the pilot's failure to obtain a weather briefing, and the weather conditions.NTSB ATL95LA160Accident · No injuriesLimited investigationFinal reportBell UH-1H · Montgomery, ALthe pilot's failure to maintain clearance from the trees.NTSB FTW95LA331Accident · No injuriesLimited investigationFinal reportGrumman G-164A · St.Francisville, LAThe pilot's failure to maintain clearance with the obstruction on short final. A factor was the low visibility.