NTSB investigations
3,485 cases where the first occurrence was “In flight collision with terrain/water”.
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\" = 230) 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" = 230) 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 CHI91FA266Accident · 1 fatalField investigationFinal reportBellanca 17-30A · Boyne City, MIThe pilot in command's failure to maintain proper altitude. A factor contributing to the accident was the pilot in command's diverted attention..NTSB SEA91LA206Accident · No injuriesLimited investigationFinal reportBeech V35B · Belgrade, MTThe pilot's failure to maintain a positive rate of climb during the takeoff. Factors contributing to the accident were the open cabin window and the pilot's diverting his attention.NTSB SEA91FA203Accident · 1 fatalField investigationFinal reportChristen Industries Pitts S-2B · Scappoose, ORThe pilot's misjudgment of altitude, while performing an aerobatic maneuver, and his failure to maintain ground clearance.NTSB FTW91FA144Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201T · Midland, TXThe pilot's inability to control the airplane due to his physiological incaapacitation. A factor was the pilot's impairment due to the usage of pain medications.NTSB CHI91DTG07Accident · No injuriesFinal reportAyres S2R · Drayton, NDMisjudged clearance by the pilot. A factor related to the accident is overconfidence in personal ability.NTSB DEN91FA110Accident · 1 fatalField investigationFinal reportCessna 177 · Hygiene, COSuicide. A factor related to the accident was: the pilot's other psychological condition.NTSB LAX91LA348Accident · Minor injuriesLimited investigationFinal reportExperimental DSA-1 · Kingman, AZThe pilot-in-command's failure to maintain the proper altitude to ensure terrain clearance while conducting low level aerobatic maneuvers, resulting in an in flight collision with terrain.NTSB NYC91FA196Accident · 2 fatalField investigationFinal reportCessna 152 · New Paltz, NYFailure of the instructor pilot (CFI) to assure that the proper altitude was maintained. A factor related to the accident was: the cfi's lack of experience in the type of operation.NTSB CHI91LA242Accident · Minor injuriesLimited investigationFinal reportAmerican AA1 · Spearville, KSThe pilot's selection of unsuitable terrain on which to perform a precautionary landing. Factors related to the accident were poor in flight/planning decision which resulted in the pilot becoming lost/disoriented.NTSB NYC91FA194Accident · 1 fatalField investigationFinal reportPiper PA-32-260 · Monongahela, PAThe failure of the pilot to achieve a proper touchdown on the runway due to diverted attention, pressure, and other psychological condition.NTSB FTW91LA138Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Wylie, TXThe pilot's failure to maintain clearance with the water. A factor was the pilot's ostentatious display.NTSB FTW91DPG18Accident · No injuriesFinal reportGrumman G-164A · Dewitt, ARThe pilot's failure to maintain proper glidepath. A factor was the berm at the approach end of the runway.NTSB BFO91FA068Accident · 4 fatalField investigationFinal reportBeech V35A · Jonesville, VAFailure of the pilot-in-command (PIC) to assure that the instrument departure procedure was followed and that the aircraft remained clear of mountainous terrain.NTSB SEA91FA183Accident · 4 fatalField investigationFinal reportCessna 177RG · Salmon, IDImproper inflight planning and decision by the pilot, and his failure to maintain sufficient altitude and clearance from mountainous/hilly terrain.NTSB FTW91LA125Accident · No injuriesLimited investigationFinal reportBell 47G-2 · Slidell, LAThe pilot performing a touchdown autorotation to unsuitable terrain. Factors were the soft terrain and the inadequate supervision by the FAA inspector.NTSB LAX91LA321Accident · No injuriesLimited investigationFinal reportPiper PA 18-135 · Gerlach, NVThe failure of the pilot to maintain adequate terrain clearance by the selection of an inappropriate cruise altitude resulting in an in flight collision with terrain.NTSB FTW91DRG04Accident · Serious injuriesFinal reportAir Tractor AT-402 · Taft, TXThe pilot's failure to maintain proper terrain clearance.NTSB CHI91LA240Accident · No injuriesLimited investigationFinal reportPiper J-3 · Saint Leo, MNPerformance data was misjudged resulting in a positive climb not being attained by the pilot. A factor related to the accident was high density altitude.NTSB SEA91FA181Accident · 2 fatalField investigationFinal reportCessna 180J · Newcastle, WYPilot factor in that he did not maintain sufficient flying speed and allowed the aircraft to enter an inadvertent stall/spin. Factors include high density altitude.NTSB NYC91LA148Accident · No injuriesLimited investigationFinal reportCessna 172N · Lincoln Park, NJThe decision of the pilot to discontinue a go-around, from an attempted landing, resulting in the airplane striking trees. A factor related to the accident was the lack of total flight experience of the student pilot.NTSB CHI91DEV02Accident · No injuriesFinal reportO'Connell Stits SA-3B · Casey, ILThe pilot's failure to maintain a proper rate of climb after takeoff. A factor in the accident was the pilot's lack of experience in model.NTSB SEA91LA177Accident · No injuriesLimited investigationFinal reportCessna 152 · Walla Walla, WAThe student pilot's poor compensation for wind conditions. Factors were downdrafts and the student pilots lack of experience in this type of operation.NTSB ANC91IA102Incident · No injuriesIncident investigationFinal reportDe Havilland DHC2 MK1 · Iliamna, AKThe pilot-in-command's attempted flight into known adverse weather conditions. Contributing to the accident was the high and gusty winds in the accident area.NTSB SEA91FA170Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Driggs, IDThe pilot's poor inflight decision and his improper compensation for wind. Factors were rising, mountainous terrain; high, gusty winds; and a high density altitude.NTSB SEA91LA168Accident · Serious injuriesLimited investigationFinal reportCessna 182A · Naches, WAThe pilot's poor in-flight decision. Factors include high density altitude, high winds and downdrafts.NTSB LAX91LA305Accident · Minor injuriesLimited investigationFinal reportRobinson R-22-B · San Jose, CAThe student pilot's failure to unlock the cyclic trim and to maintain his hover altitude. His lack of experience with the aircraft, inadequate preflight, and the uncontrolled descent were factors in the accident.NTSB SEA91LA165Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Medford, ORAn intentional porpoise. Factors include the pilot's psychological condition.NTSB LAX91LA301Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Eloy, AZThe failure of the pilot to maintain the terrain clearance of the aircraft while maneuvering for a potential emergency landing on a moonless dark night.NTSB SEA91LA158Accident · Minor injuriesLimited investigationFinal reportBeech BE-77 · Benton City, WAThe pilot's disregard of the airplane's performance capability. Contributing to the accident was high density altitude.NTSB BFO91LA065Accident · No injuriesLimited investigationFinal reportGrumman AA-5 · Clarksville, MDThe pilot's improper flare and failure to arrest his descent rate.NTSB SEA91LA150Accident · Minor injuriesLimited investigationFinal reportCessna T188C · Riverton, WYThe pilot did not maintain adequate terrain clearance. A factor to the accident was: poor inflight planning/preparation.NTSB FTW91DRA05Accident · 1 fatalFinal reportDaniel La Lee Miget Mustang M-1 · Santa Fe, TXThe pilot's performance of an aerobatic maneuver at an altitude inadequate to allow for safe recovery.NTSB CHI91LA207Accident · No injuriesLimited investigationFinal reportHughes 300C · Whitehall, MIThe pilot's failure to maintain adequate clearance from the water. A factor was the dark night light condition.NTSB NYC91LA167Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Rhinebeck, NYThe pilot did not calculated the airplane's performance data to insure that he had enough runway to clear an obstacle at the end of the field, which resulted in the airplane's landing gear striking high hedges, subsequently the pilot elected to land in a…NTSB CHI91LA205Accident · No injuriesLimited investigationFinal reportHiller UH-12D · Savoy, ILThe pilot's failure to maintain tail rotor clearance from the ground. A related factor is the pilot's lack of total experience in helicopters.NTSB CHI91LA204Accident · Minor injuriesLimited investigationFinal reportAmerican AA-1 · Dexter, MIThe pilot's delay in aborting the landing. A factor in the accident was his excessive speed on final approach.NTSB FTW91DPA02Accident · Serious injuriesFinal reportPaul M. F. Walker Pitts S-1-C · Royse City, TXThe pilot's performance of an aerobatic maneuver at an altitude too low to allow recovery.NTSB LAX91FA281Accident · 2 fatalField investigationFinal reportCessna 182Q · Fillmore, CAPoor judgement by the pilot to continue VFR flight into instrument meteorological conditions. Contributing to the accident was IFR conditions that included low ceilings and low visibility and insufficient instrument training of the pilot to deal with the IFR…NTSB CHI91DER08Accident · 1 fatalFinal reportBellanca 8GCBC · St. Hilaire, MNThe pilot's failure to maintain sufficient altitude while maneuvering.NTSB FTW91DRD06Accident · No injuriesFinal reportBell 47-G2 · White Castle, LAThe pilot's improper aircraft handling, which resulted in settling with power.NTSB SEA91LA146Accident · Minor injuriesLimited investigationFinal reportRobinson R-22 Beta · Wenatchee, WAThe pilot's failure to maintain a proper altitude. Contributing to the accident was sun glare.NTSB LAX91LA268Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Payson, AZA premature liftoff, stall, and subsequent in flight collision with terrain. A factor related to the accident was the high density altitude.NTSB LAX91LA273Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Pacoima, CAThe pilot's improper preflight planning/preparation and his failure to attain the proper altitude.NTSB SEA91LA137Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Warrenton, ORThe pilot failed to maintain proper rotor speed during a simulated autorotation.NTSB CHI91DEP10Accident · No injuriesFinal reportAllan R. Goldman Dragonfly · Kenosha, WIInadequate aircraft design and insufficient information regarding wing versus canard angle for an amateur built aircraft.NTSB CHI91DER05Accident · No injuriesFinal reportBell 47G3B1 · Lasalle, MNThe pilot's failure to maintain adequate clearance from the terrain. A related factor is the pilot's misjudged altitude above the crop.NTSB SEA91LA145Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Corvallis, ORThe pilot displayed poor in-flight planning. A factor to the accident was: the pilot did not maintain a proper altitude over mountainous terrain.NTSB LAX91LA243Accident · 2 fatalLimited investigationFinal reportCessna 182E · Eureka, CAThe non-instrument rated pilot's inadvertent flight into IMC conditions. The pilot's lack of total experience, his disregard to the preflight meteorological briefing he received, low ceilings, fog, and the mountainous terrain over which the flight was…NTSB NYC91LA152Accident · Serious injuriesLimited investigationFinal reportGlasflugel Libelle 201B · Saratoga, NYThe failure of the pilot to adequately flare when making an uphill landing. Factors related to the accident were the pilot continued attempts at finding lift which reduced his landing options when he decided to land.NTSB FTW91LA095Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Newport, ARThe pilot's improper planning which resulted in his flying into his own chemicals.