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 NYC96LA155Accident · Minor injuriesLimited investigationFinal reportCessna 150G · Turner, MEthe pilot's inadequate preflight inspection, by failing to remove the pitot tube cover, which resulted in false airspeed indications, and his failure to maintain adequate obstacle clearance from a utility pole.NTSB NYC96LA154Accident · No injuriesLimited investigationFinal reportCessna 172K · West Milford, NJthe pilot's failure in attaining the proper touchdown point, and his delay in initiating a go-around (aborted landing).NTSB ATL96LA111Accident · Minor injuriesLimited investigationFinal reportGrumman G-164 · Montezuma, GAfailure of the pilot to maintain adequate visual look out, while maneuvering on an aerial application run, which result in his failure to see-and-avoid a power line.NTSB ATL96LA110Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer 164 · Bainbridge, GAThe pilot's misjudgment of the clearance from the trees during the swath run that resulted in the collision.NTSB MIA96FA186Accident · 1 fatalField investigationFinal reportCessna 152 · New Smyrna Bch, FLthe pilot's impairment of judgment and performance because of gastroenteritis and use of the prescription drug Phenergan (promethazine).NTSB IAD96LA117Accident · No injuriesLimited investigationFinal reportBeech A100 · Manchester, NHThe pilots failure to maintain control of the aircraft during a coupled approach. A related factor was the unmonitored inoperative glide slope.NTSB SEA96LA146Accident · 1 fatalLimited investigationFinal reportGrumman American AA-5B · St Maries, IDthe pilot's impairment of judgment and performance due to a drug (marijuana), and his failure to see-and-avoid power lines. The pilot's intentional low altitude flight was a related factor.NTSB NYC96LA146Accident · No injuriesLimited investigationFinal reportCessna 172H · Cherry Tree, PAthe pilot's failure to assure that adequate takeoff distance was available to clear an obstacle.NTSB NYC96LA145Accident · Minor injuriesLimited investigationFinal reportBell 47G-5 · Carver, MAthe pilot's inadequate visual look out for obstacles, which resulted in a collision with wires and the ground.NTSB ANC96LA097Accident · No injuriesLimited investigationFinal reportBell 206B · Juneau, AKThe pilot's failure to maintain proper alignment while lifting the helicopter to a hover and inducing a dynamic roll to avoid striking a passenger.NTSB MIA96LA177Accident · Serious injuriesLimited investigationFinal reportAerostar RX-8 · Canton, MSfailure of the pilot to maintain sufficient altitude and/or clearance from the tower.NTSB MIA96LA174Accident · Minor injuriesLimited investigationFinal reportBeech 58 · Kinston, NCfailure of the pilot to maintain minimum descent altitude (MDA) during approach because of fatigue.NTSB FTW96LA290Accident · No injuriesLimited investigationFinal reportCessna 172L · Johnstown, COfailure of the pilot to maintain proper altitude/clearance from obstructions, while buzzing.NTSB LAX96LA255Accident · No injuriesLimited investigationFinal reportCessna 172 · Frazier Park, CAthe failure of the pilot to maintain terrain clearance after a misjudged approach and landing that necessitated a go-around and subsequent collision with some wires. Factors were high density altitude and an inadequate evaluation by the pilot-in-command of…NTSB CHI96LA223Accident · No injuriesLimited investigationFinal reportBell TH-13T · Mandan, NDthe pilot's failure to maintain clearance from known transmission lines. A factor relating to this accident was the sunglare which hindered the pilot's ability to see the transmission lines.NTSB CHI96LA221Accident · Minor injuriesLimited investigationFinal reportCessna 182Q · Bad Axe, MIa deer that ran onto the runway. The light condition at dusk was a related factor.NTSB ATL96FA096Accident · 2 fatalField investigationFinal reportCessna 152 · Talladega, ALfailure of the pilot to see-and-avoid an antenna that was mounted on a Forest Service watch tower. The pilot's excessively low altitude flight was a related factor.NTSB MIA96LA164Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Jonesville, SCthe pilot's inadequate visual lookout and failure to maintain altitude and/or clearance from the obstruction (power line) during low altitude flight. The lack of natural lighting at dusk was a related factor.NTSB FTW96LA274Accident · No injuriesLimited investigationFinal reportHughes 369HE · Las Cruces, NMthe pilot's failure to maintain clearance between the tail rotor and a fence while hovering.NTSB LAX96LA239Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Lamont, CAfailure of the pilot to see-and-avoid a guy wire along the border of a field that was being agriculturally treated. The sunglare, guy wire, and lack of visual cues were related factors.NTSB CHI96TA260Accident · No injuriesFinal reportSchweizer SGS 2-33AK · Mattoon, ILthe pilot's failure to maintain directional control of the glider. Factors were the runway sign and the failure of the pilot to maintain a visual lookout.NTSB SEA96LA122Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8B · Wilsonville, ORfailure of the pilot to maintain clearance from the static wire, which became shorted to a transmission wire and subsequently caused a fire to erupt on the balloon's envelope. Factors relating to the accident were: the obstructions (power line wires), and the…NTSB ATL96FA094Accident · 1 fatalField investigationFinal reportCessna 172N · Arlington, TNThe pilot's failure to maintain clearance above the trees. A factor was the dark night.NTSB CHI96LA194Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Cleveland, NDfailure of the pilot to maintain sufficient altitude or clearance from trees during an aerial application operation. The wires and trees (obstructions) were related factors.NTSB CHI96LA193Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Lowell, MIwas inadequate initial training of the pilot and inadequate flight test procedures by the FAA Designated Pilot Examiner when he reportedly had the pilot demonstrate 12 pilot operations from the FAA's practical flight test standards in 35 minutes during the…NTSB FTW96LA242Accident · Serious injuriesLimited investigationFinal reportAerostar S-60A · San Angelo, TXfailure of the pilot to maintain altitude or clearance from a tree, during an approach to land in a field.NTSB SEA96LA116Accident · No injuriesLimited investigationFinal reportCessna 172L · Sisters, ORthe pilot's inadequate compensation for wind conditions during a go-around, which resulted in his failure to maintain proper runway alignment. Factors relating to the accident were: the variable/gusty crosswind condition, and the proximity of the hanger and…NTSB FTW96LA238Accident · Serious injuriesLimited investigationFinal reportCessna 172RG · Leadville, COInadequate preflight planning and preparation and failure to follow aircraft operating procedures and directives. Factors were high density altitude, inadequate training of the flight instructor and insufficient standards and requirements for flight…NTSB SEA96LA111Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-1B · Coquille, ORthe pilot's inadequate evaluation of wind conditions, and his subsequent failure to initiate a go-around in a timely manner, which resulted in his inability to maintain clearance with trees during the go-around. Factors relating to the accident included a…NTSB MIA96FA148Accident · 1 fatalField investigationFinal reportAeronca O-58B · Greenville, SCthe pilot's failure to maintain adequate altitude/clearance from power lines while maneuvering at a low altitude.NTSB FTW96LA236Accident · Minor injuriesLimited investigationFinal reportRockwell S-2R · Dumas, ARFailure of all personnel concerned to identify the unsafe/hazardous condition, which resulted from a visual restriction, due to trees near the intersection of the road and runway.NTSB SEA96LA106Accident · No injuriesLimited investigationFinal reportHughes 369HS · Arock, ORthe pilot's failure to see and avoid the transmission wire. A factor was the low altitude flight.NTSB MIA96LA147Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Barbour Island, GAthe pilot's failure to adequately compensate for gusty wind conditions.NTSB FTW96LA232Accident · Minor injuriesLimited investigationFinal reportGrumman G-164B · Newport, ARfailure of the pilot to maintain clearance from the power line.NTSB LAX96LA214Accident · Serious injuriesLimited investigationFinal reportSchweizer G-164B · Corning, CAthe pilot misjudged the airplane's clearance from wires he was flying beneath. A contributing factor was the presence of light turbulence.NTSB ATL96LA088Accident · No injuriesLimited investigationFinal reportAero Commander 100 · Jesup, GAthe pilot's inadequate preflight planning/preparation, and his failure to remain clear of the fence during takeoff.NTSB CHI96LA187Accident · No injuriesLimited investigationFinal reportCessna P206 · Goshen, INthe parachute equipment was not properly maintained by the parachutist. A factor related to the accident was the inadvertent deployment of the parachute.NTSB LAX96LA204Accident · 1 fatalLimited investigationFinal reportGrumman G-164 · Colusa, CAfailure of the pilot to remain clear of the power lines. Factors relating to the accident were: Lack of visual cues at dawn, and the power lines.NTSB FTW96LA225Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Bridgeport, TXthe pilot's improper preflight by failing to ensure the mixture control was properly set before takeoff, and his failure to abort the takeoff (while there was sufficient runway remaining).NTSB ANC96LA076Accident · Minor injuriesLimited investigationFinal reportBeech 99C · Barrow, AKan in-flight collision with a bird.NTSB ANC96LA071Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Big Lake, AKthe pilot's improper planning/decision, which resulted in his failure (or inability) to maintain clearance from trees after encountering gusty crosswind conditions. The wind condition and close proximity of trees were related factors.NTSB CHI96LA156Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Crystal Lake, ILthe pilot not flying a proper glidepath for the displaced runway threshold.NTSB IAD96LA076Accident · 2 fatalLimited investigationFinal reportCessna 150 · Welch, WVthe pilot's impairment of judgment and performance due to alcohol which led to his failure to maintain sufficient altitude to clear obstacles. A factor was his intentional buzzing.NTSB NYC96LA102Accident · Minor injuriesLimited investigationFinal reportBeech A36 · Olean, NYthe pilot's improper IFR procedure by not maintaining the minimum descent altitude (MDA) during the ILS localizer approach. Factors relating to the accident were: low ceiling, fog, and weather below minimums for landing.NTSB ATL96FA084Accident · 3 fatalField investigationFinal reportLake 4-200 · Melbourne, FLThe pilot's failure to maintain clearance from trees while maneuvering. A factor was the tailwind condition.NTSB SEA96LA089Accident · No injuriesLimited investigationFinal reportCessna A185E · Cascade, IDthe pilot's improper planning/decision, his failure to ensure that the airplane would maintain proper clearance from obstructions (trees), and his delay in aborting the takeoff. The soft/wet runway and tailwind were related factors.NTSB LAX96TA186Accident · No injuriesFinal reportHughes 369 · Yuma, AZfailure of the pilot to maintain altitude and/or clearance from obstacles, while maneuvering a low altitude at night. Factors relating to the accident were: darkness and the lack of visual cues.NTSB FTW96LA190Accident · Serious injuriesLimited investigationFinal reportDeaton JUNGSTER-1 · Mcalester, OKthe pilot's failure to maintain obstacle clearance.NTSB CHI96FA141Accident · 1 fatalField investigationFinal reportPiper PA-25-150 · Buffalo, MOfailure of company/operator personnel to install the wing and landing gear (strut) fairings after modifying the airplane for a supplemental type certificate (STC), and improper planning/decision by the pilot. Factors relating to the accident were: the…NTSB MIA96LA125Accident · No injuriesLimited investigationFinal reportRans S6ES · Bayou La Batre, ALthe pilot's inadequate compensation for wind conditions. The gusty/crosswind condition was a related factor.