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 LAX97LA160Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Llano, CAthe student pilot's inadequate compensation for the crosswind condition, and his failure to maintain proper altitude and clearance from the boundry fence, during an approach to land on the runway. Factors relating to the accident were: the crosswind, and…NTSB ANC97LA056Accident · No injuriesLimited investigationFinal reportBoeing 747-400 · Anchorage, AKAn in-flight collision with a large bird.NTSB NYC97LA063Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Lincoln Park, NJThe pilot's failure to maintain adequate obstacle clearance due to his diverted attention in attempting to re-illuminate the runway lights, which resulted in an inflight collision with a tree.NTSB ATL97LA052Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G-103-TWIN II · Lancaster, SCthe pilot's improper use of the spoilers, while approaching to land, which allowed the glider to get low on final approach and strike trees. The pilot's lack of recent flying experience and lack of experience in the make and model of glider were related…NTSB MIA97LA101Accident · No injuriesLimited investigationFinal reportSchweizer SGS 1-26E · Benton, TNThe failure of the pilot to maintain altitude and clearance from the trees on a ridge line.NTSB FTW97LA134Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-502 · Paragould, ARThe pilot's failure to maintain clearance from trees resulting in jammed control surfaces. A factor was that aircraft control was not possible by the pilot.NTSB LAX97LA127Accident · 1 fatalLimited investigationFinal reportPassadori Norman Breezy · Gilroy, CAThe pilot's delayed decision to reverse course while climbing into rising terrain, and his failure to maintain an adequate airspeed margin which resulted in a stall/mush into trees and terrain.NTSB FTW97LA131Accident · Serious injuriesLimited investigationFinal reportHiller UH-12E · Donna, TXThe pilot's failure to maintain clearance with the power lines during an aerial application flight. A factor was the power lines.NTSB FTW97LA127Accident · 1 fatalLimited investigationFinal reportAir Tractor AT-402 · Pine Bluff, ARfailure of the pilot to see-and-avoid the tower. The proximity of the tower was a related factor.NTSB FTW97LA123Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Manchaca, TXThe pilot's continued VFR flight into instrument meteorological conditions and his failure to maintain obstacle clearance. A factor was the weather condition.NTSB FTW97FA122Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Westminster, TXThe pilot's failure to maintain clearance during an intentional low altitude maneuver. A factor was the transmission line.NTSB SEA97LA072Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Glide, ORfailure of the pilot to maintain clearance from a power transmission line. Factors relating to the accident included ambient light conditions, which made the power line hard to see.NTSB IAD97LA062Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS-233A · Woodbine, MDThe pilot misjudged his altitude during approach.NTSB FTW97LA110Accident · 2 fatalLimited investigationFinal reportCessna 152 · Plaquemine, LAThe pilot's failure to maintain proper altitude and clearance from transmission wires. Factors were, the dark night, low cloud ceiling, and fog.NTSB NYC97LA053Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Nanjemoy, MDthe pilot's inadequate compensate for the wind conditions and failure to maintain adequate obstacle clearance during the initial climb after takeoff. The unfavorable wind condition and proximity of trees were related factors.NTSB FTW97LA105Accident · No injuriesLimited investigationFinal reportPiper PA-36-375 · Danevang, TXThe utility's company failure to notify affected parties of the downed line, and the pilot's failure to maintain clearance with the downed wire. A factor was the downed wire.NTSB LAX97LA104Accident · 1 fatalLimited investigationFinal reportPiper PA-18A · Livingston, CAthe pilot's failure to see and avoid power lines. A factor was the pilot's poor judgment in conducting unwarranted low altitude maneuvering.NTSB NYC97LA054Accident · No injuriesLimited investigationFinal reportCessna 208B · Covington, KYThe pilot's failure to maintain the airplane on the ILS glide slope, which resulted in a descent below the glide path, and the inadvertent in-flight collision with a utility pole. Contributing factors were sleet/snow, dark night conditions, and the pole.NTSB LAX97LA100Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Madera, CAThe pilot's failure to maintain adequate clearance from obstructions and his inadequate visual outlook.NTSB SEA97LA059Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Madras, ORThe pilot's inadvertent visual flight rules (VFR) flight into instrument meteorological conditions (IMC). Factors include the pilot's improper decision to fly under a low ceiling while in mountainous/hilly terrain, and his encounter with fog and low clouds…NTSB IAD97LA046Accident · No injuriesLimited investigationFinal reportCessna 172P · Chesapeake, OHthe pilot's failure to maintain proper altitude during the approach at night. Related factors were: darkness, and the pilot's lack of night flying experience.NTSB FTW97FA097Accident · 2 fatalField investigationFinal reportCessna 152 · Guthrie, OKThe flight instructor's failure to obtain/maintain clearance with the power line. A factor was the sunglare from the setting sun, which could have impaired the flight instructor's ability to see the power line.NTSB ATL97LA036Accident · No injuriesLimited investigationFinal reportRobinson R22 · Wiggins, MSthe student pilot misjudged rotor blade clearance from a utility pole, which resulted in a collision. The proximity of the pole was a related factor.NTSB MIA97FA070Accident · 4 fatalField investigationFinal reportBell 206-B3 · Fort Lauderdale, FLThe pilot's incapacitation by carbon monoxide from undetermined sources which led to his diminished ability to see and avoid a radio tower.NTSB CHI97FA059Accident · Minor injuriesField investigationFinal reportCessna 401 · Crystal, MNfailure of the pilot-in-command to ensure adequate removal of airframe ice from the aircraft during preflight.NTSB FTW97LA085Accident · No injuriesLimited investigationFinal reportCessna 172N · Steamboat Spgs, COFailure of the flight instructor and the dual student to maintain an adequate visual lookout. Factors were the flight instructor's inadequate supervision of the flight, inadequate altitude in which to clear obstacles, and the dual student's lack of…NTSB MIA97FA063Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Okeechobee, FLthe noninstrument-rated pilot's decision to conduct a VFR flight into instrument meteorological flight conditions. The weather was a factor.NTSB SEA97LA047Accident · No injuriesLimited investigationFinal reportBarriger RV-6 · The Dalles, ORThe pilot's failure to maintain clearance from a powerline during an intentional low altitude maneuver.NTSB MIA97GA059Accident · 1 fatalFinal reportAyres S2RHG-T65 · Guaviare, Colombiathe pilot's failure to maintain adequate altitude/clearance while maneuvering at a low altitude.NTSB FTW97LA074Accident · No injuriesLimited investigationFinal reportBeech C90A · Rio Grande City, TXThe pilot's failure to maintain clearance with the tower. Factors were the low ceilings and the pilot's diverted attention to his navigation.NTSB IAD97LA040Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Colombia Staton, OHinadequate supervision by the flight instructor (CFI), and his failure to ensure that sufficient altitude and/or clearance was maintain from obstructions (trees) during the approach. Darkness was a related factor.NTSB LAX97LA079Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5A · Banning, CAThe pilot's intentional low flight in an area of foothills and canyons at an altitude insufficient to maintain clearance from obstacles.NTSB MIA97LA046Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Mulberry, FLThe pilot's failure to check that the spoiler handle was locked in the retracted position prior to takeoff.NTSB NYC97LA034Accident · No injuriesLimited investigationFinal reportMaule M-5 · Levant, MEthe pilot's inadequate compensation for wind conditions, and his failure to maintain clearance from tree(s) during an attempted go-around. The crosswind and proximity of tree(s) were related factors.NTSB NYC97LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Baltimore, MDthe student pilot's premature rotation and inadequate supervision by the flight instructor (CFI), which resulted in failure of the flight crew to obtain adequate airspeed during takeoff for a proper rate of climb. Trees at the departure end of the runway were…NTSB IAD97LA031Accident · 2 fatalLimited investigationFinal reportMooney M20F · Wellsville, NYDescent below the published minimum descent altitude followed by collision with the surrounding terrain.NTSB FTW97LA058Accident · No injuriesLimited investigationFinal reportAerospatiale AS350B · East Cameron 71failure of the pilot to maintain clearance from an object (crane/bucket). The gusty wind condition and proximity of the crane/bucket were related factors.NTSB IAD97FA025Accident · 1 fatalField investigationFinal reportAero Commander 681 · Mansfield, OHthe pilot's early descent below the minimum descent altitude (MDA), while preparing to land from an instrument approach, and his failure to maintain adequate altitude and clearance from obstruction(s).NTSB LAX97LA057Accident · Serious injuriesLimited investigationFinal reportBell 206B · Mcgregor Point, HIthe pilot's failure to maintain control of the aircraft and distance from the pole.NTSB MIA97LA028Accident · 1 fatalLimited investigationFinal reportNorth American T28B · Somerville, TNthe pilot misjudged his altitude/clearance above trees on terrain that was higher than the surrounding terrain, while performing an aerobatic maneuver.NTSB FTW97TA046Accident · No injuriesFinal reportAerospatiale AS-355-F1 · Taos, NMThe pilot's failure to maintain directional control. A factor was terrain induced turbulence.NTSB CHI97LA035Accident · No injuriesLimited investigationFinal reportCessna 150 · Chesterfield, MOthe pilot's failure to maintain an adequate visual lookout.NTSB FTW97FA044Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Fort Worth, TXthe pilots' continued descent of the aircraft below decision height. Factors contributing to the accident were the fog, the dark night illumination, one of the pilot's impairment due to use of marihuana, and both pilots' fatigue.NTSB CHI97LA019Accident · Minor injuriesLimited investigationFinal reportMaule MX-7-235 · Hubbard Lake, MIthe pilot's inadequate compensation for wind conditions, and failure to maintain proper alignment with the airstreip during the go-around (aborted landing). The crosswind and proximity of trees were related factors.NTSB FTW97LA034Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Mancos, COfailure of the pilot to maintain clearance from the windsock, during a hover/pedal-turn after lift-off.NTSB FTW97LA030Accident · No injuriesLimited investigationFinal reportBell 206B-3 · Creole, LAthe pilot's inadequate preflight by failing to remove the 100 foot long line and the external cargo basket from the helicopter before takeoff, and/or his failure to ensure that clearance/altitude was maintained from the fence.NTSB IAD97FA014Accident · 2 fatalField investigationFinal reportCessna 172L · Brandy Station, VAthe certificated flight instructor's failure to ensure that proper altitude/clearance was maintained above the terrain and trees, while on final approach. Darkness was a related factor.NTSB ATL97LA013Accident · Serious injuriesLimited investigationFinal reportLet L-13 · Benton, TNfailure of the flight crew to maintain altitude/clearance above runway obstacles, and inadequate supervision by the flight instructor. Factors relating to the accident were sunglare on the canopy, and the proximity of obstacles (trees) to the runway.NTSB CHI97LA016Accident · 1 fatalLimited investigationFinal reportHughes 369 · Vestaburg, MIfailure of the pilot to maintain clearance with the wires.NTSB NYC97MA005Accident · Minor injuriesClass 1 · MajorFinal reportMcDonnell Douglas MD-88 · Flushing, NYThe Safety Board's full report is available at www.ntsb.gov/publictn/publictn.htm. NTSB Report AAR-97/03. the inability of the captain, because of his use of monovision contact lenses, to overcome his misperception of the airplane's position relative to the…