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 ATL05LA111Accident · 1 fatalLimited investigationFinal reportPiper J3C-65 · Yadkinville, NCThe pilots failure to maintain adequate clearance from object and inadequate visual look-out while maneuvering resulted in an in-flight collision with power lines.NTSB DFW05CA172Accident · Serious injuriesData collectionFinal reportGarlick Helicopters OH-58A+ · Graham, TXThe pilot's failure to maintain clearance with the wire while maneuvering during an aerial application flight. Low altitude flight is a contributing factor.NTSB CHI05LA149Accident · 1 fatalLimited investigationFinal reportCessna 188 · Senath, MOThe pilot's failure to maintain clearance from the tower guy wires. A factor was the extra antenna guy wire.NTSB DFW05LA162Accident · 1 fatalLimited investigationFinal reportWsk-Pzl Mielec M18B · Eudora, ARThe pilot's failure to maintain clearance from the tree.NTSB CHI05CA151Accident · No injuriesData collectionFinal reportKirby Christen Eagle · Wheeling, ILThe pilot's inadequate compensation for the wind conditions, and his failure to maintain obstacle clearance, which resulted in the airplane drifting during the landing flare and impacting the taxiway light.NTSB ATL05FA098Accident · 2 fatalField investigationFinal reportFairchild M-62A-3 · Williamson, GAThe pilot's failure to follow the before takeoff checklist and attempted a takeoff with flaps extended, which resulted in an in-flight collision with trees.NTSB NYC05FA099Accident · Serious injuriesField investigationFinal reportBell 206L · New York, NYThe pilot's inadequate preflight planning, which resulted in an attempted takeoff with an overweight helicopter, and subsequent impact with a pier and water. Factors were a high ambient temperature and unfavorable winds.NTSB SEA05CA116Accident · No injuriesData collectionFinal reportTaylorcraft BC12-D · Yellow Pine, IDThe pilot's delay in executing a go-around which resulted in his failure to obtain altitude/clearance with trees.NTSB DFW05CA176Accident · No injuriesData collectionFinal reportCessna A188B · Truman, ARThe pilot's failure to maintain clearance with the power lines while maneuvering during an aerial application flight. A contributing factor was the sunglare.NTSB DFW05IA150Incident · No injuriesIncident investigationFinal reportCessna 208B · Clarendon, TXThe loss of total engine power due to damage of the compressor stator vanes caused by a foreign object. A contributing factor was an in-flight ingestion of bird(s).NTSB DFW05LA138Accident · 1 fatalLimited investigationFinal reportStearman D75 · Taylor, TXThe pilot's failure to maintain clearance from an unmarked transmission line. A contributing factor was low altitude selected by the pilot.NTSB CHI05LA130Accident · Minor injuriesLimited investigationFinal reportPilatus PC-6 · Sturtevant, WIFailure of the jump plane pilot to maintain clearance from the parachutist descent area/drop zone until assured that all jumpers had landed, and the parachutist's failure to maintain an adequate visual lookout for the jump plane during all phases of the jump.…NTSB ATL05CA089Accident · Minor injuriesData collectionFinal reportHughes TH-55 · Cornelia, GAThe pilot's failure to maintain adequate object clearance, which resulted in the in-flight collision with terrain, and the subsequent rollover.NTSB LAX05LA187Accident · Serious injuriesLimited investigationFinal reportBell 47G-4A · Bakersfield, CAthe pilot's inadequate visual lookout and failure to maintain clearance from the power lines.NTSB LAX05CA188Accident · No injuriesData collectionFinal reportRobinson R-22 Beta II · Jean, NVthe student's failure to maintain adequate main rotor rpm when performing a180-degree autorotation, and the instructor's inadequate supervision and delayed remedial action. A factor in the accident was the high density altitude.NTSB DFW05CA133Accident · No injuriesData collectionFinal reportGrumman 164-B · Fontaine, ARThe pilot's failure to maintain clearance during a downwind takeoff with a full load of fertilizer. Factor contributing to the accident were the prevailing tailwind and the high density altitude.NTSB DFW05LA126Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-602 · Ralls, TXThe pilot's failure to maintain clearance from the antenna tower. Contributing factors were the recency of the tower's construction and the lack of obstruction lights on the tower.NTSB DFW05LA125Accident · 2 fatalLimited investigationFinal reportAerostar International S53A · Shreveport, LAThe pilot's failure to maintain clearance from electrical power lines.NTSB DEN05CA078Accident · No injuriesData collectionFinal reportBell 47G-5A · Brush, COThe pilot's failure to maintain clearance from the truck trailer during takeoff. A factor contributing to this accident was the truck trailer.NTSB CHI05CA147Accident · Minor injuriesData collectionFinal reportBell 47G · Twin Brooks, SDThe pilot's inadequate lookout and his failure to maintain clearance with the power lines. A factor was the low altitude at which the helicopter was operating.NTSB DFW05CA127Accident · Serious injuriesData collectionFinal reportRobinson R22 Beta · Rock Springs, TXThe pilot's failure to maintain clearance with a static line. A contributing factor was the low altitude.NTSB DEN05LA075Accident · No injuriesLimited investigationFinal reportCessna T188C · Fowler, COthe pilot's failure to maintain visual lookout and clearance, resulting in an in-flight collision with transmission lines.NTSB CHI05LA114Accident · 1 fatalLimited investigationFinal reportCessna A188B · Ludell, KSThe pilot's failure to maintain clearance from trees during an aerial application maneuver. The trees and the sun glare were contributing factors.NTSB DEN05CA073Accident · Minor injuriesData collectionFinal reportChampion 7ECA · Fort Collins, COthe pilot's inadequate preflight planning/preparation which failed to assure adequate takeoff performance to clear obstacles. Contributing factors included the miscalculated weight and balance and the high density altitude.NTSB NYC05CA076Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Indian Head, MDThe pilot's failure to maintain adequate altitude/clearance while on final approach, which resulted in an in-flight collision with trees. A factor in this accident was the gusty wind conditions.NTSB SEA05CA086Accident · No injuriesData collectionFinal reportWilliams Helicopter UH-1B · Uniontown, WAThe pilot's failure to maintain clearance from an object while maneuvering, which resulted in the main rotor blades striking a power pole. The power pole was a factor in the accident.NTSB MIA05LA096Accident · 1 fatalLimited investigationFinal reportde Havilland DHC-6 · Deland, FLThe pilot's inadequate visual lookout.NTSB IAD05LA057Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · Hampton, NHThe pilot's improper decision to depart with a tailwind, and his failure to perform preflight performance calculations.NTSB ATL05LA073Accident · 1 fatalLimited investigationFinal reportAnderson Mini Mustang · Mullins, SCThe pilot's inadequate visual lookout and the pilot's failure to maintain clearance from trees while maneuvering.NTSB DFW05FA099Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Jefferson, TXThe pilot's failure to maintain clearance from an unmarked transmission line. A contributing factor was the low altitude flight.NTSB SEA05FA072Accident · 2 fatalField investigationFinal reportStinson 10-A · Oak Harbor, WAThe pilot's failure to adequately plan the approach for landing and maintain clearance from trees during the go-around. A tailwind and trees were factors.NTSB DEN05FA124Accident · 2 fatalField investigationFinal reportPiper PA-22-135 · Kremmling, COthe pilot's failure to maintain clearance from terrain.NTSB IAD05FA052Accident · 2 fatalField investigationFinal reportPiper PA-28R-201 · Green Creek, NJThe flight crew's failure to maintain terrain clearance while executing a practice published instrument approach in night visual meteorological conditions. A factor in the accident was the dark night.NTSB CHI05LA086Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Waunakee, WIThe pilot's inadequate preflight planning and the delay in aborting the landing which resulted in the subsequent insufficient airspeed. Factors associated with the accident were the night light conditions, the fence, and the pole which the airplane contacted.NTSB IAD05LA050Accident · No injuriesLimited investigationFinal reportPiper PA-31P-350 · Ridgefield, CTThe pilot's improper IFR procedure by flying below the minimum descent altitude, which resulted in the airplane striking trees.NTSB NYC05CA065Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Sussex, NJThe pilot's failure to insure adequate obstacle clearance while conducting a practice forced landing approach, and the flight instructor's failure to take remedial action, which resulted in an in-flight collision with wires.NTSB ATL05CA064Accident · No injuriesData collectionFinal reportPiper PA28-151 · Eastman, GAThe certified flight instructors failure to maintain a visual look out while demonstrating a simulated emergency landing resulting in an in-flight collision with a known transmission wire.NTSB DFW05CA091Accident · No injuriesData collectionFinal reportCessna 172N · Rio Grande City, TXThe pilot's failure to maintain clearance from objects, and his improper compensation for wind conditions while landing. A contributing factor was the gusty wind condition.NTSB ANC05CA071Accident · No injuriesData collectionFinal reportAerospatiale AS350-B2 · Valdez, AKThe pilot's failure to maintain clearance from an object while hover taxiing, which resulted in the main rotor blades striking a sign.NTSB SEA05CA060Accident · No injuriesData collectionFinal reportBirtch Kitfox II · Dillard, ORThe pilot's failure to maintain clearance from obstacles while in cruise flight at low altitude, which resulted in an inflight collision with a power line. A factor was the pilot's decision to fly at low altitude.NTSB SEA05CA055Accident · Minor injuriesData collectionFinal reportCessna 172H · Waldport, ORThe pilot's failure to attain sufficient altitude/clearance during the takeoff initial climb, which resulted in an inflight collision with trees. A factor was the tall grass on the turf runway, which slowed the airplane's acceleration during the takeoff roll.NTSB DFW05CA079Accident · No injuriesData collectionFinal reportAir Tractor AT-402 · Dumas, ARThe pilot's failure to maintain clearance from the power lines.NTSB DFW05CA075Accident · No injuriesData collectionFinal reportSchweizer SGS1-26B · Midlothian, TXThe pilot's misjudgment in distance/altitude and his failure to maintain clearance from a tree while on final to approach to landing. Contributing factors were the lack of thermal lift and the gusty wind conditions.NTSB SEA05CA050Accident · No injuriesData collectionFinal reportAviat Husky A-1 · Kalispell, MTThe pilot's failure to maintain clearance from a tree located off the departure end of his private airstrip during an aborted landing attempt. Factors include trees located near the departure end of the runway.NTSB DFW05FA059Accident · 2 fatalField investigationFinal reportBeech BE-36 · Brownwood, TXThe pilots failure to maintain proper altitude and clearance while on final approach to land. Contributing factors were the pilot's lack of familiarity with the geographic area, the dark night light conditions, the non-availability of a visual approach glide…NTSB DFW05CA077Accident · No injuriesData collectionFinal reportCessna 182 · Graham, TXThe airplane's collision with a deer during a go-around. A contributing factor was the prevailing night condition.NTSB CHI05FA056Accident · 5 fatalField investigationFinal reportCessna 421C Riley Turbine E · Overland Park, KSThe pilot's failure to maintain adequate altitude/clearance during cruise flight, resulting in collision with trees. Contributing factors were the low altitude and low ceiling.NTSB LAX05LA064Accident · 1 fatalLimited investigationFinal reportJimmy Hill Lancair 235 · El Cajon, CAthe pilot's failure to maintain the proper glidepath to avoid obstacles and terrain.NTSB ATL05LA042Accident · 1 fatalLimited investigationFinal reportBeech 35 · Knoxville, TNThe pilot's failure to maintain adequate obstacle clearance, which resulted in the in-flight collision with trees. A factor was dark night.NTSB LAX05FA062Accident · 1 fatalField investigationFinal reportCessna 150J · Marana, AZthe failure of the pilot to maintain an adequate altitude and clearance from obstructions that resulted in an in-flight collision with power lines.