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 MIA89LA196Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Minter City, MSFailure of the pilot to see and avoid the powerline. The power line was a contributing factor.NTSB FTW89FA132Accident · 1 fatalField investigationFinal reportCessna 152 · Arlington, TXPoor judgement of the pilot, due to impairment from consumption of alcohol, and his failure to maintain proper altitude while maneuvering. Factors related to the accident were: darkness, the pilot's recent use of drugs, and his lack of flight experience.NTSB SEA89LA131Accident · Minor injuriesLimited investigationFinal reportAeronca 65-CA · Prineville, ORThe pilot's failure to maintain adequate clearance from trees.NTSB MKC89FA156Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Medicine Lodge, KSThe pilot misjudged clearance above a house (residence) that he was buzzing and allowed the aircraft to collide with the attached antenna.NTSB FTW89LA131Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Blanco, TXInadequate in-flight planning/decisions by not identifying the wind direction along with the failure to maintain airspeed. Contributing to the accident was the tailwind, wires and trees.NTSB DEN89DTI03Accident · 1 fatalFinal reportCessna T188C · Red Lodge, MTImproper inflight decision by the pilot and his failure to attain sufficient altitude. Rising terrain, high density altitude, and trees were considered to be contributing factors.NTSB DEN89LA161Accident · Minor injuriesLimited investigationFinal reportRaven RX-7 · Albuquerque, NMInadequate visual lookout by the pilot. Contributing to the accident were the power lines.NTSB BFO89LA055Accident · Serious injuriesLimited investigationFinal reportHughes 500D · Williamson, WVPilot's failure to see and avoid the wire which crossed the end of the field in which he was taking off.NTSB DEN89FA152Accident · 1 fatalField investigationFinal reportBeech E33 · Angel Fire, NMImproper planning/decision by the pilot, his premature rotation for takeoff and subsequent failure to obtain or maintain sufficient speed to climb, and his failure to abort the takeoff (while there was sufficient rwy remaining). Contributing factors were: the…NTSB BFO89LA049Accident · No injuriesLimited investigationFinal reportBell 47J · Fruitland, MDPoor judgement of the pilot by flying, while physically impaired by alcohol, and his misjudgement of clearance between the helicopter and the structure. The dark night and object (structure) were considered to be contributing factors.NTSB ATL89FA171Accident · 2 fatalField investigationFinal reportDassault-Breguet Falcon 20 · Cartersville, GAFailure of the pilot-in-command (PIC) to assure that the aircraft maintained a climb profile after takeoff. Factors related to the accident were: dark night, the crew's lack of visual perception at night, the pic's lack of rest (fatigue), and the copilot's…NTSB ATL89DKG04Accident · 1 fatalFinal reportAir Tractor AT-301 · Americus, GAThe pilot's failure to properly survey the area in which he would be conducting aerial application flights and his failure to see and avoid powerlines while performing aerial application.NTSB SEA89LA120Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Centralia, WAThe pilot misjudged his clearance over trees, which resulted in an in-flight tail rotor strike with the trees and loss of tail rotor control. The trees were a related factor.NTSB DEN89DTI01Accident · 1 fatalFinal reportPiper PA-25-235 · Conrad, MTThe pilot's failure to see the guy wire in time to avoid colliding with it.NTSB MKC89LA138Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Grain Valley, MOFailure of the student pilot to maintain proper runway alignment, while aborting a bounced landing. Factors related to the accident were: the pilot's improper flare and lack of experience in the make and model of aircraft, the right crosswind, and the…NTSB CHI89FA112Accident · Minor injuriesField investigationFinal reportHughes 269C · Lockport, ILImproper flight technique by the PIC during a takeoff from a confined area.NTSB MIA89FA176Accident · 1 fatalField investigationFinal reportBoeing A-75 · Daytona Beach, FLThe biplane pilot failed to see and avoid the collision with the banner being towed by the other airplane.NTSB FTW89DPJ06Accident · No injuriesFinal reportPiper PA-18A · Eva, OKThe pilot's failure to maintain visual lookout. A factor was the pilot's limited visual perception due to the ground vehicle.NTSB BFO89LA044Accident · No injuriesLimited investigationFinal reportCessna 172A · Madison Heights, VAStudent pilot's failure to maintain proper airspeed during the landing attempt which resulted in the initiation of a go-around. Contributing factors to the accident were the pilot's poor preflight planning and his becoming disoriented during the flight. Also…NTSB ATL89FA158Accident · 3 fatalField investigationFinal reportBalloon Works Firefly 8B · Garner, NCImproper planning/decision by the pilot, and his delay in initiating a climb as the Balloon converged on the tv tower.NTSB LAX89FA212Accident · 2 fatalField investigationFinal reportHughes 269C · Rainbow Valley, CAImproper planning/decision by the pilot and his inadequate visual lookout (failure to see and avoid the obstruction). Factors related to the accident were: the adverse weather conditions, the pilot's decision to fly in marginal VFR weather, and the…NTSB MIA89FA172Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Ashland, VAImproper go-around by the pilot by not maintaining a climb and obtaining proper altitude before turning. The pilot's poor approach and the trees were considered to be contributing factors.NTSB CHI89DEC05Accident · Serious injuriesFinal reportJob Sonerai II · Fowlerville, MIThe pilot's discontinuing visual lookout to scan gages before clearing a known obstacle on the departure path from the runway. A factor in the accident is the pilot's lack of experience in this model airplane.NTSB SEA89LA100Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 · Prineville, ORThe pilots inadequate visual lookout and failure to maintain clearance from obstructions, resulting in the tail rotor impacting a road sign and subsequent loss of anti-torque control.NTSB SEA89LA098Accident · Serious injuriesLimited investigationFinal reportBell 47G-2 · Buena, WAThe pilot's failure to maintain an adequate visual lookout and clearance to avoid the power lines.NTSB MKC89LA123Accident · No injuriesLimited investigationFinal reportAir Tractor AT-400 · Poplar Bluff, MOThe pilot in command misjudged the clearance of the aircraft's vertical stabilizer from the power lines.NTSB FTW89DRA06Accident · No injuriesFinal reportGrumman G-164B · Lissie, TXA bird strike which resulted in foreign object damage to the engine compressor. A berm and the lack of suitable terrain for a forced landing were contributing factors.NTSB NYC89LA171Accident · No injuriesLimited investigationFinal reportHughes 369HS · Niagara Falls, NYFailure of the pilot to see and avoid the cables.NTSB ATL89LA155Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Trinity, NCThe pilots failure to select a suitable takeoff area based on the weight of the aircraft and the atmospheric conditions at the time of takeoff.NTSB ATL89LA153Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-135 · Medina, OHFailure of airport management to establish a displaced threshold which would provide adequate obstruction clearance. Factors contributing to the accident were the power lines, the utility pole and the dusk light conditions.NTSB SEA89LA094Accident · No injuriesLimited investigationFinal reportCessna 182B · Bend, ORThe pilot allowed his attention to be diverted by a crosswind and failed to maintain clearance from trees on approach.NTSB FTW89DRD05Accident · Minor injuriesFinal reportGrumman G-164A · Gueydan, LAVisual lookout was not maintained by the pilot in command, which resulted in the collision with a power transmission line during a swath run.NTSB MKC89FA117Accident · Serious injuriesField investigationFinal reportCessna 172M · Oakland, ARPilot electing to buzz persons on the lake at low altitude and colliding with power lines.NTSB LAX89LA207Accident · No injuriesLimited investigationFinal reportCessna A185F · Jackson, CAThe pilot did not establish a climb rate sufficient enough to clear trees before turning towards them during a go-around. Contributing to the accident were gusty crosswinds which changed to a tailwind when the aircraft turned to the right and the pilots…NTSB ATL89LA152Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Indian Trail, NCThe pilot's delay in aborting the landing after a bounced landing. Contributing factors were: improper flare by the pilot and the transmissions lines.NTSB LAX89FA203Accident · 1 fatalField investigationFinal reportBell 206B · Camp Verde, AZFailure of the pilot to maintain adequate altitude to clear obstructions in his flight path and visually detect obstructions in order to avert a collision.NTSB MKC89LA113Accident · Minor injuriesLimited investigationFinal reportAmerican AA5-B · Valentine, NEThe pilot delayed initiating a go-around after not attaining a proper touchdown point during the approach to land. Contributing factors were the high density altitude and the trees off the departure end of the runway.NTSB FTW89DRD03Accident · 1 fatalFinal reportSchweizer G-164A · Maxie, LAFailure of the pilot to maintain clearance from the trees. A factor related to the accident was: the presence of trees near the field where fertilizer was to be dispensed.NTSB DEN89DTK01Accident · 1 fatalFinal reportPiper PA-36-300 · Agar, SDThe pilot's failure to maintain an adequate clearance with the powerlines. The powerline is considered to be a contributing factor to the accident.NTSB BFO89FA033Accident · 2 fatalField investigationFinal reportBell UH-1B · Oldtown, MDFailure of the pilot to see-and-avoid the obstruction (inadequate visual lookout). Factors related to the accident were: the obstruction (static wires), and the lack of visual cues for the pilot to detect the wires.NTSB SEA89LA091Accident · Minor injuriesLimited investigationFinal reportPazmany PL-4A · Concrete, WAAn improper low pass and clearance with trees misjudged by pilot.NTSB NYC89LA140Accident · Serious injuriesLimited investigationFinal reportNorth American Navion A · North Creek, NYThe pilot's inadequate preflight planning/preparation for the takeoff.NTSB MIA89FA151Accident · 1 fatalField investigationFinal reportCessna TU206F · Immokalee, FLThe pilot's failure to establish the descent angle which would attain the proper touchdown point. Consequently, the airplane collided, in flight, with the airport boundary fence.NTSB FTW89DQG03Accident · Minor injuriesFinal reportWeatherly 201B · Miami, TXThe pilot's failure to maintain adequate clearance from a known obstacle during agricultural spray flight operations,NTSB MKC89LA112Accident · No injuriesLimited investigationFinal reportCessna 152 · Warrensburg, MOThe failure of the CFI to visually acquire and maintain clearance from power lines, which the airplane subsequently contacted.NTSB SEA89LA088Accident · Serious injuriesLimited investigationFinal reportBell 214B-1 · Ketchikan, AKThe pilot misjudging clearance from trees during a hover descent.NTSB LAX89LA194Accident · Minor injuriesLimited investigationFinal reportCessna R172E · Young, AZThe pilots decision to land at the restricted airport which had a tree located 20 feet from the centerline of the runway and his failure to maintain proper alignment with the centerline once he made the decision to land there.NTSB DEN89FA117Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Livingston, MTThe poor judgement displayed by the pilot when he maneuvered the airplane at extremely low altitude over mountainous terrain. During the flight the pilot misjudged the pull-up required and struck trees.NTSB ATL89FA142Accident · 1 fatalField investigationFinal reportEmbraer EMB-110-P1 · Mt. Pleasant, TNPilot attempted to make a VFR landing in instrument conditions that were below minimums for the published instrument approach and collided with trees and the ground after allowing the airplane to descend below the proper altitude.NTSB SEA89LA078Accident · No injuriesLimited investigationFinal reportCessna 172 · Lynden, WAThe pilot delayed in aborting the landing and failed obtain or maintain sufficient airspeed to keep the aircraft from mushing after lift-off. Factors related to the accident were: obstructions near the approach end of the runway, failure of the pilot to…