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 DEN90LA191Accident · No injuriesLimited investigationFinal reportCessna 172L · Mason, TXThe failure of the pilot to maintain an adequate visual lookout.NTSB LAX90LA324Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Watsonville, CAImproper handling of the aircraft by the student pilot, which resulted in his failure to attain sufficient airspeed to climb after takeoff, and the instructor's (cfi's) inadequate supervision.NTSB LAX90DUJ08Accident · Serious injuriesFinal reportRockwell S-2R · Yuma, AZFailure of the pilot to select a cruise altitude which would ensure adequate clearance from obstructions. A factor in the accident was the dark night which inhibited the pilot's ability to see the obstruction.NTSB SEA90FA182Accident · 1 fatalField investigationFinal reportCessna 150M · Prospect, ORThe pilot's failure to maintain a proper altitude during his approach. The dark night condition was a contributing factor.NTSB FTW90FA179Accident · 1 fatalField investigationFinal reportBeech 58 · Conway, ARThe pilot's failure to attain the proper touchdown point and his delayed decision to abort the landing. Factors were the weather conditions.NTSB ATL90DLG02Accident · 1 fatalFinal reportCessna A188B · Aiken, SCThe pilot's delayed pull-up during an aerial application swath which resulted in the collision with a static wire associated with electrical transmission lines.NTSB ATL90LA168Accident · Serious injuriesLimited investigationFinal reportSchleicher ASK-21 · Memphis, TNAn inflight collision with a tree due to misjudging his glidepath.NTSB SEA90LA181Accident · No injuriesLimited investigationFinal reportCessna U206 · Lewistown, MTThe pilot did not maintain an adequate lookout while maneuvering which resulted in a collision with a transmission wire.NTSB MIA90LA179Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Geneva, FLThe pilots failure to retract the flaps to the takeoff setting during a touch-and-go landing.NTSB CHI90LA256Accident · Serious injuriesLimited investigationFinal reportBoeing B75N1 · Marseilles, ILThe pilot-in-command's failure to maintain adequate visual outlook to avoid collision with a wire while conducting intentional low level flight.NTSB FTW90DPG14Accident · Minor injuriesFinal reportGrumman G-164B · Dumas, ARThe inadvertent stall encountered during the turn to reverse direction.NTSB DEN90LA180Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B1 · Canon City, COThe pilot's failure to maintain an adequate pattern altitude and the possible existence of adverse winds due to the surrounding terrain.NTSB FTW90LA174Accident · Minor injuriesLimited investigationFinal reportCessna C172N · Marietta, OKFailure of the pilot to attain the proper climb rate after takeoff resulting in the aircraft colliding with trees at the departure end of the runway. Contribuing to the accident was the pilot in commands failure to account for high density altitude.NTSB FTW90LA166Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Denver City, TXThe pilot's improper leaning of the fuel mixture.NTSB DEN90FA176Accident · 1 fatalField investigationFinal reportCameron O-84 · Taos, NMThe pilot's improper decision to attempt a go-around. A factor was the unfavorable wind encountered late in the attempted landing.NTSB CHI90LA242Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Blissfield, MIThe pilot's inadequate visual lookout which resulted in a collision with a utility wire.NTSB CHI90LA241Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Schaumburg, ILThe pilot's failure to attain a proper climb rate after takeoff. Factors related to the accident are misjudgement of the aircraft takeoff weight, and overconfidence in the ability of the aircraft.NTSB FTW90FA164Accident · Serious injuriesField investigationFinal reportHughes 269C · Shreveport, LAThe pilot's failure to maintain clearance from the obstruction. Factors related to the accident were: the lack of visual ques due to the light conditions at dusk, the ground observer's lack of assistance and lack of experience in the type of operation, and…NTSB FTW90FA160Accident · 4 fatalField investigationFinal reportAerospatiale/Socata TB-10 · Ada, OKImproper planning/decision by the pilot, which resulted in his failure to attain sufficient airspeed for a climb profile. Factors related to the accident were: the pilot allowed the weight and balance of the aircraft to exceed the certified limits, his use of…NTSB LAX90DVA10Accident · Serious injuriesFinal reportGrumman-Schweizer G-164B · Westley, CAThe pilot's failure maintain obstacle clearance.NTSB FTW90LA157Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Kansas, OKStudent pilot's failure to execute a go-around in a timely manner.NTSB CHI90DEP09Accident · Serious injuriesFinal reportCessna 182 · Columbus, WIThe skydiver's panic and failure to depart the aircraft as instructed. Contributing was the skydiver's lack of total experience in this type of operation.NTSB NYC90LA195Accident · Serious injuriesLimited investigationFinal reportBeech BE-19 · Shirley, NYFailure of the PIC to supervise the actions of the dual student.NTSB FTW90DPG09Accident · 1 fatalFinal reportGrumman G164A · Osceola, ARThe pilot's failure to maintain proper clearance from the power lines.NTSB NYC90DGT01Accident · Minor injuriesFinal reportCalvart HP-18 · York Springs, PAThe glider pilot's misjudged approach to landing, which resulted in the glider overshooting the landing field and impacting trees.NTSB CHI90DEC04Accident · Serious injuriesFinal reportBell 47 D-1 · Stockbridge, MIThe restricted visual lookout which resulted from the canopy fogging up.NTSB SEA90LA160Accident · No injuriesLimited investigationFinal reportAlfred Stevens KEN Rand KR-2 · Ellensburg, WAThe pilot did not maintain a proper altitude above the terrain or visual lookout which resulted in a collision with a transmission wire.NTSB LAX90DVA08Accident · Minor injuriesFinal reportHiller UH-12-E · Los Banos, CAThe pilot's failure to maintain a lookout for obstructions along his swath run.NTSB CHI90LA222Accident · No injuriesLimited investigationFinal reportNaaman Haren Kitfox 1 · Grundy Center, IAGo-around delayed by the pilot in command.NTSB NYC90LA189Accident · Serious injuriesLimited investigationFinal reportBell 206 · Athens, OHThe pilot's failure to visually acquire and maintain clearance from the powerline(s). Contributing to the accident was the adverse weather conditions.NTSB CHI90DEV09Accident · 1 fatalFinal reportPietenpol AIR Camper · Minonk, ILThe pilot's inattention to visual lookout.NTSB CHI90DTG03Accident · Minor injuriesFinal reportEagle DW-1 · Jamestown, NDPilot's failure to maintain clearance from the powerline during an aerial application manuever.NTSB CHI90DCJ01Accident · 1 fatalFinal reportCessna A188B · Amherst, NEThe pilot's failure to see and avoid power lines in his area of operation.NTSB CHI90LA220Accident · No injuriesLimited investigationFinal reportSchleicher ASK-21 · Plainfield, ILThe glider pilot's improper aircraft handling at low atitude.NTSB LAX90DXQ02Accident · Minor injuriesFinal reportLeffler/Mcfarlane LM-1 · Sierraville, CAPilot's failure to see and avoid a tree during his landing approach.NTSB NYC90FA176Accident · 3 fatalField investigationFinal reportPiper PA-23-250 · North Andover, MAThe controller issued an unauthorized alternate missed approach procedure that did not provide adequate terrain clearance, and the pilot delayed obtaining a proper rate of climb during the missed approach. Factors related to the accident were: darkness and…NTSB CHI90DET04Accident · Serious injuriesFinal reportContinental Copters MK 5A Tomcat · Constantine, MIThe pilot's failure to see and avoid power lines in his area of operation.NTSB FTW90GA146Accident · 1 fatalFinal reportRobinson R22B · Tahlequah, OKThe pilot's failure to maintain adequate altitude.NTSB NYC90FA171Accident · 1 fatalField investigationFinal reportLake LA-4-200 · Gt. Barrington, MAThe pilot in command's failure to properly maintain the engine, the inadequate annual maintenance inspection, low compression, and improper magneto timing. A factor was the resultant deteriorated climb performance.NTSB MIA90LA160Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Plymouth, FLThe pilots decision to depart for his destination airport in the path of approaching thunderstorms resulting in the encounter with wind gusts during landing which exceeded his limitations.NTSB LAX90FA265Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Apple Valley, CAImproper preflight planning/decision by the pilot. Factors related to the accident were: failue of the pilot to configure the aircraft's flaps for a soft field takeoff, his improper use of stabilator trim, high density altitude, soft runway, and trees near…NTSB SEA90LA142Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Dupuyer, MTPilot's misjudged touchdown and delay in initiating the balked landing.NTSB NYC90LA168Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Gt. Barrington, MAThe pilot's failure to maintain adequate clearance from tree during the precautionary landing. Factor was a loss of thermal lift.NTSB FTW90LA143Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350D · Berwick, LAPilot in command's failure to see and avoid obstacles in the landing zone. Contributing to the accident was the pilot's lack of familiarity with the landing zone.NTSB CHI90LA179Accident · No injuriesLimited investigationFinal reportCessna 150 · Columbia, MOInadequate visual outlook by the PIC.NTSB SEA90LA138Accident · No injuriesLimited investigationFinal reportTaylorcraft F-19 · Darrington, WAThe inflight encounter with turbulent downdraft winds that resulted in a vertical descent from which the pilot could not recover with full power applied.NTSB ATL90FA144Accident · 1 fatalField investigationFinal reportCessna 305A · Fruitdale, ALThe pilot exercised poor judgment by attempting to operate the airplane while impaired by alcohol.NTSB LAX90FA252Accident · 3 fatalField investigationFinal reportCessna T210N · Pinon, AZFailure of the pilot to attain the proper touchdown point during the landing, her delay in initiating a go-around (aborted landing), and her failure to remain clear of power lines on rising terrain during the aborted landing. Factors related to the accident…NTSB NYC90LA183Accident · No injuriesLimited investigationFinal reportCessna 310R · Mansfield, OHAn unavoidable collision with a deer while taking off which bent the drag brace and prevented it from locking. Factors related to the accident were the night conditions which reduced the pilots visibility to the illuminated area of the landing lights.NTSB CHI90LA173Accident · No injuriesLimited investigationFinal reportCessna C177B · Northport, MIPilot's delayed decision to abort the landing, and the aircraft's resultant inadequate clearance/altitude and impact with trees.