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 SEA99LA095Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Big Sandy, MTThe pilot's failure to maintain clearance between the wire and his aircraft. A transmission wire and downdraft were factors.NTSB LAX99LA226Accident · Minor injuriesLimited investigationFinal reportEnstrom F28C · Kaunakakai, HIThe pilot encountered a dust devil during the takeoff transition from a dirt and grass area resulting in a loss of vision, disorientation, and subsequent collision with trees.NTSB CHI99FA190Accident · 1 fatalField investigationFinal reportCessna 182J · Satanta, KSthe preflight planning/preparation and the missed approach not performed by the pilot. The obstruction clearance not maintained by the pilot was an additional cause. Contributing factors were the low ceiling and the fog.NTSB LAX99FA214Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Bass Lake, CAInadequate in-flight planning and decision making resulted in a failure to maintain clearance from terrain. A factor in the accident was the pilot's low total time and lack of experience in this make and model of airplane.NTSB FTW99FA171Accident · 1 fatalField investigationFinal reportHeilig-Reading Emeraude CP 301A · Altus, ARThe pilot's failure to maintain clearance with a wire, during an approach to a private airstrip.NTSB LAX99LA217Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Needles, CAThe pilot's inadequate compensation for the gusty crosswind condition and subsequent failure to maintain alignment with the road used for takeoff, which resulted in a collision with a construction sign during the initial climb.NTSB ANC99LA077Accident · Minor injuriesLimited investigationFinal reportCessna 180A · Fairbanks, AKThe pilot's inadequate in-flight planning/decision during a go-around. A factor was the pilot's failure to maintain the proper glide path to the runway.NTSB MIA99LA182Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Seymour, TNThe failure of the pilot to perform a go-around earlier resulting in a long landing, insufficient runway remaining to stop, and subsequent in flight collision with a marked power line during an aborted landing.NTSB NYC99LA138Accident · Minor injuriesLimited investigationFinal reportEnstrom F-28 · Cincinnati, OHThe pilot's inadequate evaluation of the weather conditions at the time of departure, which resulted in a downwind takeoff. A factor in the accident was the change in wind direction.NTSB DEN99LA102Accident · No injuriesLimited investigationFinal reportSchweizer SGU-2-22E · Hobbs, NMPilot incapacitation (loss of consciousness) due to dehydration and hyperventilation. Factors were the turbulence and excessive workload (task overload) that induced anxiety/apprehension, and striking the sign and the pole.NTSB NYC99FA136Accident · 1 fatalField investigationFinal reportAmerican Eurocopter AS-350B · Ashcamp, KYThe pilot's inadequate visual look out which resulted in an in-flight collision with wires.NTSB CHI99FA174Accident · 3 fatalField investigationFinal reportPiper PA-28-151 · Drummond Island, MIthe altitude/clearance not obtained/maintained and the inadequate planning/decision by the pilot-in-command. The exceeded aircraft performance was an additional cause. The unfavorable wind and trees were contributing factors.NTSB NYC99FA123Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · West Dover, VTWas the failure of the pilot to maintain control of the airplane during an aborted landing. Factors were the pilot's lack of familiarity with the airplane, the variable winds, and night conditions.NTSB SEA99LA077Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Covington, WAThe student pilot's inadequate recovery from a bounced landing, and his subsequent improper execution of the go-around procedure, resulting in collision with trees off the departure end of the runway. Factors included the student pilot's lack of total…NTSB LAX99FA199Accident · 1 fatalField investigationFinal reportCessna 180J · Wickenburg, AZThe pilot's failure to maintain altitude/clearance from ground obstacles. A factor was the pilot's diverted attention in this accident.NTSB MIA99LA160Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Orlando, FLThe pilots misjudgment of altitude during an attempted banner tow pick-up. This resulted in the banner becoming entangled around the main landing gear. The pilot made a go-around. On landing rollout the banner became entangled around a runway light, and the…NTSB ANC99LA064Accident · No injuriesLimited investigationFinal reportde Havilland DHC-6-300 · Anchorage, AKAn in-flight collision with a bird.NTSB SEA99LA069Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lyman, WAThe pilot-in-command's improper execution of takeoff procedures, and his delay in aborting the takeoff. Contributing factors were the fence post and trees.NTSB DEN99LA079Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Richfield, UTThe pilot's failure to maintain adequate altitude/clearance from the wires while maneuvering during an aerial application.NTSB LAX99LA187Accident · No injuriesLimited investigationFinal reportCessna 150J · Alderpoint, CAThe pilot's inadequate compensation for the existing turbulent, gusty wind conditions during the approach. Contributing factors were the pilot's delayed go-around maneuver, the gusty and turbulent winds, and the tree.NTSB FTW99LA135Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Taylor, TXThe pilot's failure to maintain a proper glide path, which resulted in a collision with a wire. A factor was the dark night condition.NTSB CHI99GA155Accident · 2 fatalFinal reportBell OH-58A · Poplar Bluff, MOThe tail rotor's impact with the blue warm-up jacket and the subsequent overload of the tail rotor drive shaft. A contributing factor was the absence of the helicopter's entry doors.NTSB CHI99LA152Accident · No injuriesLimited investigationFinal reportCessna A188B · Lincoln, KSthe altitude/clearance not obtained by the pilot and the unsuitable takeoff area selected by the pilot. Factors to the accident were the high, soft, and wet grass runway.NTSB FTW99LA140Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Brownwood, TXThe failure of the pilot-in-command to use the manufacturer's published checklist and extend the flaps prior to takeoff. A factor was the pilot's fatigued physiological condition as a result of extended flight and ground duty hours.NTSB MIA99LA154Accident · No injuriesLimited investigationFinal reportRyan ST-A · Leesburg, FLThe pilot's failure to maintain adequate clearance from the fence.NTSB LAX99FA177Accident · 2 fatalField investigationFinal reportAerostar Rally RX-8 · Morgan Hill, CAThe pilot's selection of an inadequate takeoff site that did not allow sufficient horizontal clearance from obstacles in the takeoff path, and, his failure to ensure that all burners were connected to fuel sources, which reduced the available climb capability…NTSB ANC99TA058Accident · 1 fatalFinal reportBell UH-1B · Wrangell, AKThe pilot-in-command's failure to maintain sufficient distance from a transmission wire, arcing of the transmission wire, the failure of company personnel to utilize a nonconducting cable, and an inadequate procedure utilized by the construction project…NTSB MIA99LA148Accident · No injuriesLimited investigationFinal reportCessna 172N · Eagleville, TNThe dual's student failure to maintain adequate altitude/clearance from the wire during takeoff/initial climb. Also causal was the certified flight instructor's inadequate supervision.NTSB CHI99LA138Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Bonner Springs, KSthe pilot's failure to obtain sufficient altitude during the aborted landing to clear obstacles at the end of the field. Factors associated with the accident were poor preflight planning/preparation, the tailwind, the telephone pole, and the trees.NTSB ATL99LA079Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Seneca, SCThe pilot's failure to maintain adequate airspeed which resulted in a stall and subsequent impact with trees.NTSB NYC99FA098Accident · 1 fatalField investigationFinal reportCessna 150G · Watertown, NYThe pilot-in-command misjudged altitude, which resulted in an in-flight collision with utility wires at the approach end of the airstrip. A factor was the pilot's failure to wear his corrective lenses.NTSB SEA99LA141Accident · No injuriesLimited investigationFinal reportBell 212 · Snoqualmie, WAClearance from an object was not maintained. A tree was a factor.NTSB CHI99LA135Accident · No injuriesLimited investigationFinal reportCessna 172M · Mayview, MOthe pilot's selection of unsuitable terrain for the attempted precautionary landing. Factors to the accident were the overcast weather condition, inadequate preflight planning by the pilot, the inadvertent flight into instrument meteorological conditions, and…NTSB MIA99LA139Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Apex, NCthe pilot's failure to maintain control of the airplane resulting in the airplane drifting, and subsequently impacting with trees.NTSB ATL99FA074Accident · 1 fatalField investigationFinal reportCessna 172 · Savannah, GAThe pilot's selection of the wrong runway for landing and his delayed go-around, which resulted in the collision with trees. A factor was the tailwind on landing.NTSB FTW99LA117Accident · No injuriesLimited investigationFinal reportCessna 170B · Fayetteville, ARThe pilot's failure to obtain the proper climb rate resulting in an inadvertent stall. Factors were the rising terrain and the variable winds.NTSB SEA99TA051Accident · Minor injuriesFinal reportI.C.A. Brasov IS-28B2 · North Plains, ORThe second pilot did not maintain clearance from power lines. The pilot-in-command did not adequately supervise the second pilot, and the second pilot's diverted attention and lack of familiarity with the geographic area were factors.NTSB NYC99LA089Accident · No injuriesLimited investigationFinal reportAmerican AA-5 · Stiefler Corner, PAThe pilot diverting his attention inside the cockpit, and allowing the airplane to enter instrument meteorological conditions, resulting in an in-flight collision with a tree.NTSB MIA99LA129Accident · No injuriesLimited investigationFinal reportMbb BK 117 A-3 · Sarasota, FLThe pilot-in-command's failure to maintain a visual lookout while maneuvering in a hover resulting in the tail rotor colliding with a building.NTSB SEA99LA059Accident · No injuriesLimited investigationFinal reportCessna 172D · Glenns Ferry, IDThe failure of both pilots to see-and-avoid wires crossing the river. Factors included: transmission wires; inattention of both pilots to the aircraft's flight path; and the pilots' low-altitude flight.NTSB FTW99LA114Accident · No injuriesLimited investigationFinal reportCessna 172N · Cleburne, TXThe pilot's failure to maintain adequate altitude/ clearance from the wires.NTSB FTW99LA108Accident · No injuriesLimited investigationFinal reportCessna 172M · Midlothian, TXThe pilot's failure to maintain clearance with the powerlines. Factors were the low ceilings and the dusk light illumination.NTSB CHI99LA111Accident · 1 fatalLimited investigationFinal reportCessna A188B · Atwood, KSThe pilot's failure to maintain clearance from obstacles.NTSB LAX99LA123Accident · No injuriesLimited investigationFinal reportCessna 172M · Reno, NVThe pilot's inadequate compensation for the crosswind condition and his failure to maintain runway alignment during the crosswind landing.NTSB LAX99LA116Accident · Minor injuriesLimited investigationFinal reportBell 206B · Delhi, CAThe pilot's failure to maintain clearance while landing in proximity to high vegetation, which resulted in the inadvertent contact of the spray boom to the trees.NTSB CHI99FA102Accident · No injuriesField investigationFinal reportDouglas DC-9-15F · Kansas City, MOingestion of birds into both engines, resulting in foreign object damage and the subsequent partial power loss to both engines. A factor relating to this accident was the dark night.NTSB NYC99LA067Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Sublett, KYThe pilot's improper decision to continue the flight with a perceived excessive fuel consumption, and delaying his decision to execute a precautionary until night, which resulted in the airplane impacting wires. Factors in the accident were the pilot's lack…NTSB MIA99LA094Accident · No injuriesLimited investigationFinal reportCessna 182J · Franklin, NCThe failure of the pilot to maintain directional control of the airplane on final approach resulting in the in-flight collision with trees and the ground.NTSB NYC99LA064Accident · No injuriesLimited investigationFinal reportBoeing 757 · Covington, KYA flock birds were ingested into both engines, resulting in substantial damage to the engines.NTSB SEA99LA036Accident · No injuriesLimited investigationFinal reportPiper J-5A · Rexburg, IDThe pilot's failure to maintain clearance from power lines.