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 CHI06LA138Accident · 1 fatalLimited investigationFinal reportHughes 269A · Berlin Center, OHThe pilot flew at a low altitude and failed to maintain clearance from the wire. A factor was the wire.NTSB CHI06LA139Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hale, MIThe pilot's inadequate compensation for the crosswind condition and failure to maintain clearance from the tree. Factors were the crosswind and the tree.NTSB DFW06CA139Accident · Minor injuriesData collectionFinal reportAllstar PZL SZD 51-1 Junior · Cherry Valley, ARThe pilot's failure to maintain clearance from a tree while on final to approach to landing. A contributing factor was the loss of thermal lift on final approach.NTSB ATL06FA078Accident · 2 fatalField investigationFinal reportCessna 150L · Cumming, GAThe pilot's failure to consider the appropriate aircraft performance data prior to takeoff, and his improper use of the wing flaps during takeoff, which resulted in reduced climb performance and an in-flight collision with a residence. A factor associated…NTSB ANC06CA051Accident · Minor injuriesData collectionFinal reportLanford Antares MA-33 · Trapper Creek, AKThe non-certificated pilot's failure to maintain altitude/clearance during final approach for landing, which resulted in the airplane striking a tree, and an in-flight collision with terrain. A factor associated with the accident was the tree.NTSB NYC06CA111Accident · Serious injuriesData collectionFinal reportQuicksilver GT-400 · West Middlesex, PAThe pilot's failure to maintain adequate clearance from trees during the initial climb.NTSB DEN06CA073Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Cody, WYthe pilot's failure to maintain clearance with a parked vehicle during the approach to land on a dirt road. Contributing factors were the pilot's improper decision to land near an unsuitable landing area, and the parked vehicle.NTSB NYC06CA109Accident · Serious injuriesData collectionFinal reportCessna 152 · Shamokin, PAThe pilot's failure to recover from a bounced landing, and her improper use of flaps during an aborted landing, which resulted in an in-flight collision with trees.NTSB DFW06CA116Accident · Minor injuriesData collectionFinal reportHeliotech H-250 · Woodville, TXThe pilot's failure to maintain clearance with obstructions at the departure end of the airstrip during an aborted landing. A contributing factor was dusk light conditions.NTSB LAX06LA147Accident · No injuriesLimited investigationFinal reportChristen Industries A-1 · Creston, CAThe pilot's failure to maintain an adequate clearance from obstacles while intentionally flying at a low altitude.NTSB CHI06FA117Accident · 5 fatalField investigationFinal reportCessna U206G · Bloomington, INThe pilot's continued descent below decision height and not maintaining adequate altitude/clearance from the trees while on approach. Factors were the the night lighting conditions, and the mist.NTSB DEN06LA067Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Arkansas City, KSthe pilot's failure to maintain clearance from the guide wire resulting in the airplane striking the wire and subsequently impacting the terrain.NTSB DFW06CA109Accident · No injuriesData collectionFinal reportCessna 150M · Roanake, TXThe pilot's failure to maintain clearance from an unmarked transmission wire. A contributing factor was the low altitude flight.NTSB DFW06CA107Accident · No injuriesData collectionFinal reportPiper PA-22 · Tecumseh, OKThe pilot's failure to maintain clearance from the trees. Contributing factors were the pilot's inadequate preflight planning/preparation and the high-density altitude.NTSB DFW06LA103Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-602 · Meridian, MSThe pilot's failure to maintain clearance from trees. Contributing factors were the drug impairment and low maneuvering altitude.NTSB DFW06FA102Accident · 2 fatalField investigationFinal reportRobinson R44 II · Fredericksburg, TXThe pilot's failure to maintain clearance with the power lines. Contributing factors were the dusk light condition and the pilot's non-compliance with standard taxi and takeoff procedures.NTSB CHI06LA105Accident · 1 fatalLimited investigationFinal reportCessna 177 · Blackburn, MOThe pilot's failure to maintain obstacle clearance from the power line during low altitude maneuvering. A factor was the power line.NTSB ANC06LA044Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350BA · Haines, AKThe pilot's failure to maintain adequate clearance from an object while landing a helicopter at a remote site, which resulted in the main rotor blades striking a tree.NTSB ATL06LA059Accident · Serious injuriesLimited investigationFinal reportBrantly Helicopter B2B · Cullman, ALThe pilot's failure to maintain a visual look out while maneuvering resulting in an in-flight collision with wires and the ground. A factor in the accident was the pilot's lack of recent experience in rotorcraft operations.NTSB LAX06CA140Accident · No injuriesData collectionFinal reportPiper PA-31-310 · Victorville, CAan in-flight collision with a bird.NTSB CHI06FA094Accident · 4 fatalField investigationFinal reportPiper PA34-200T · Branson, MOThe pilot's failure to maintain sufficient airspeed, which resulted in an inadvertent stall/spin while maneuvering to return to the departure airport for landing after declaring an emergency for unspecified reasons. Additional factors were the low cloud…NTSB NYC06FA078Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Old Bridge, NJThe pilot's improper decision to conduct visual approach and landing in instrument meteorological conditions, and his failure to maintain adequate clearance from trees and terrain during the go-around. Factors in the accident were the low cloud ceiling and…NTSB LAX06CA125Accident · Minor injuriesData collectionFinal reportCessna 172N · Compton, CAcontrol interference by the student pilot during a go-around that resulted in an in-flight collision with power lines.NTSB ANC06LA032Accident · No injuriesLimited investigationFinal reportDouglas DC-3 · Beluga, AKThe pilot's failure to maintain altitude/clearance from trees on final approach, which resulted in an in-flight collision with trees.NTSB LAX06LA123Accident · 1 fatalLimited investigationFinal reportSchweizer 269C-1 · Valencia, CAThe certified flight instructor's failure to maintain an adequate clearance from objects.NTSB NYC06LA073Accident · 1 fatalLimited investigationFinal reportCessna 182D · Weyers Cave, VAThe pilot's improper decision to maneuver at a low altitude at night, and his failure to maintain adequate altitude/clearance, which resulted in a collision with power lines. A factor in this accident was the night light conditions.NTSB NYC06FA072Accident · 4 fatalField investigationFinal reportLancair LC41-550FG · Stafford, VAThe pilot's failure to execute the published missed approach. Factors included the night lighting conditions, low ceilings and fog.NTSB DEN06FA043Accident · 3 fatalField investigationFinal reportCessna 182E · Austin, COthe pilot's failure to maintain clearance from the transmission wire resulting in the airplane's outboard wing portion to be severed, and the subsequent loss of control and ground impact. Factors contributing to the accident were the pilot's impairment from…NTSB ATL06CA043Accident · No injuriesData collectionFinal reportCessna 172P · Birmingham, ALAn in-flight collision with a deer during a go around, which resulted in damage to the left main landing gear and subsequent collapse of the left main landing gear.NTSB ATL06FA038Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Camden, ALThe pilots failure to maintain altitude and clearance during a visual descent which resulting in an in-flight collision with trees and the ground for undetermined reasons.NTSB SEA06MA047Accident · 4 fatalMajor investigationFinal reportCessna 560 · Carlsbad, CAThe captain's delayed decision to execute a balked landing (go-around) during the landing roll. Factors contributing to the accident include the captain's improper decision to land with a tailwind, his excessive airspeed on final approach, and his failure to…NTSB NYC06CA056Accident · Serious injuriesData collectionFinal reportPiper PA-28-140 · East Killingly, CTThe flight instructor's delayed decision to discontinue the simulated forced landing, which resulted in a collision with trees.NTSB NYC06CA060Accident · No injuriesData collectionFinal reportCessna 305A · Seboeis, METhe pilot's failure to maintain clearance from power lines, while attempting to land on a frozen lake.NTSB MIA06CA045Accident · No injuriesData collectionFinal reportSchewizer 233 · Immokalee, FLThe pilot's failure to maintain clearance during the final approach to land, which resulted in an impact with trees, and a hard landing.NTSB DFW06TA054Accident · Serious injuriesFinal reportAerospatiale AS350-B2 · Eagle Pass, TXThe pilot's failure to maintain clearance from the unmarked transmission lines. A factor was the pilot's diverted attention while monitoring ground activity.NTSB CHI06LA060Accident · No injuriesLimited investigationFinal reportCessna 310R · St. Charles, MOThe in-flight collision with a duck during cruise flight resulting in a ruptured fuel tank and the strobe/light assembly electrical short resulting in a fire to the right wing tip tank. Contributing factors were the dusk light conditions.NTSB LAX06CA084Accident · No injuriesData collectionFinal reportCessna T206H · Palo Alto, CAthe pilot's failure to maintain proper runway alignment, which resulted in a collision with multiple objects.NTSB SEA06FA039Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Burlington, WAThe pilot's failure to maintain the published minimum descent altitude and not adhering to the published missed approach procedures, which resulted in an in-flight collision with trees and terrain. Factors contributing to the accident were low ceilings and…NTSB MIA06FA039Accident · 3 fatalField investigationFinal reportRobinson R44 · Grand Ridge, FLThe pilot's continued flight into known adverse weather, and his impairment, which resulted in an in-flight collision with trees and terrain during cruise flight.NTSB ATL06FA030Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Peachtree City, GAThe pilot's failure to maintain sufficient altitude while performing an instrument approach in instrument meteorological conditions, which resulted in an in-flight collision with trees and terrain.NTSB DFW06CA048Accident · Minor injuriesData collectionFinal reportBell 206L-4 · Washington, LAThe in-flight collision with a bird and the pilot's physical impairment (vision), directional control was not possible.NTSB ATL06CA026Accident · Serious injuriesData collectionFinal reportEurocopter France AS-350-B2 · Jasper, ALThe pilot's failure to maintain a visual look out, and proper altitude clearance during a low level flight, resulting in an in-flight collision with a power line.NTSB ANC06LA014Accident · Minor injuriesLimited investigationFinal reportTaylorcraft F-19 · Chenga Bay, AKThe pilot's failure to maintain adequate altitude/clearance during takeoff initial climb, which resulted in an in-flight collision with trees, and subsequent collision with the ground.NTSB LAX06LA058Accident · 1 fatalLimited investigationFinal reportCessna 177RG · Dixon, CAthe pilot's intentional flight at low altitude and failure to maintain obstacle clearance with a high tension static line. The glare from the setting sun was a factor.NTSB SEA06CA024Accident · No injuriesData collectionFinal reportCessna 210-5 · Lopez Island, WAThe pilot's failure to maintain adequate clearance from an airport sign during the visual approach. The sign was a factor in the accident.NTSB LAX06FA049Accident · 1 fatalField investigationFinal reportNavion G · Imperial, CAThe pilot's failure to maintain clearance from a tree and transmission wires while performing a low altitude maneuver. Also causal was the pilot's impaired judgment and performance due to alcohol ingestion.NTSB CHI06FA037Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Atlanta, NEThe non-instrument rated private pilot not maintaining clearance from the marked tower and his continued flight into adverse weather during cruise flight. Factors were the marked tower and the low ceilings present at the accident.NTSB LAX06CA046Accident · No injuriesData collectionFinal reportCameron Balloons N-180 · Rancho Santa Fe, CAthe pilot's inadvertent deactivation of the number 2 burner, which resulted in an increased rate of descent and a collision with a tree short of the intended landing zone.NTSB DEN06GA017Accident · 1 fatalFinal reportCessna 182R · Alpine, WYthe pilot's intentional low level flight/maneuver. A contributing factor was his exercising poor judgment.NTSB CHI06FA032Accident · 1 fatalField investigationFinal reportAero Commander 500B · Gaylord, MIThe clearance not maintained with terrain during a nonprecision approach. Contributing factors were the ceiling, visibility, night conditions, and trees.