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 FTW01LA077Accident · Serious injuriesLimited investigationFinal reportErcoupe 415-C · Houston, TXthe pilot's failure to execute a go-around after becoming low on a visual approach.NTSB SEA01LA061Accident · Minor injuriesLimited investigationFinal reportEurocopter AS-350 B2 Ecureuil · Mazama, WAThe pilot's failure to maintain aircraft control. Snow covered terrain, high and variable wind conditions, and failure of attaining the proper touchdown point were factors.NTSB DEN01FA066Accident · 1 fatalField investigationFinal reportCessna T210L · Howard, COthe pilot's continuation of a VFR flight into instrument meteorological conditions, and his subsequent failure to maintain terrain clearance. Contributing factors were his failure to obtain a preflight weather briefing, and his failure to obtain any in-flight…NTSB SEA01FA060Accident · 1 fatalField investigationFinal reportCessna U206G · Mica, WAThe pilot's continued flight into instrument meteorological conditions. Contributing factors were fog, low ceilings, drizzle/mist, rising terrain, and the non-availability of a functioning transponder.NTSB SEA01LA058Accident · Serious injuriesLimited investigationFinal reportAvia Stroitel AC-5m · Bozeman, MTthe pilot's improper remedial action upon experiencing the unexpected opening of the aircraft's canopy during the initial part of the takeoff climb. Factors include his attention being diverted to the open canopy, his failure to use a checklist to ensure he…NTSB CHI01LA098Accident · No injuriesLimited investigationFinal reportCessna 170B · South Haven, MNThe pilot's failure to maintain altitude/clearance from the terrain during the maneuver to avoid the tree line. Factors to the accident were the diminished aircraft handling, the pilot's maneuver to avoid the tree line, the unsuitable terrain for takeoff…NTSB DEN01LA060Accident · No injuriesLimited investigationFinal reportBell 407 · Jackson, WYThe pilot's failure to maintain adequate lateral and vertical clearance during landing. Factors were the clouds and snow-covered high terrain.NTSB SEA01LA054Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Seattle, WABoth pilots' exceedance of the proper descent rate during the autorotative descent. Factors included the helicopter's low altitude at maneuver initiation, the failure of both pilots to maintain the proper airspeed during the descent, and both pilots' delay in…NTSB SEA01LA052Accident · No injuriesLimited investigationFinal reportCessna 402B · Billings, MTBest rate-of-climb single-engine speed was not maintained. Delayed remedial action was a factor.NTSB SEA01LA051Accident · No injuriesLimited investigationFinal reportLandry Gyrobee · Chehalis, WAThe pilot-in-command's reverse application of cyclic to counteract a right drift during the takeoff roll in a gyroplane whose controls had been designed reverse of standard. Contributing factors were the gusty wind conditions and the pilot's "expectancy" or…NTSB DEN01FA064Accident · 3 fatalField investigationFinal reportBeech V35 · Wendover, UTThe pilot flying at an altitude insufficient to clear surrounding terrain. Contributing factors were the pilot becoming lost/disoriented, his subsequent spatial disorientation, and dark night conditions.NTSB DEN01LA054Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Angel Fire, NMthe pilot's failure to maintain control of the airplane during landing. Contributing factors were the crosswind, the pilot exceeding the published maximum demonstrated crosswind component, and the snow bank.NTSB CHI01LA090Accident · No injuriesLimited investigationFinal reportBeech 95-55 · Scottsbluff, NEthe checklist not followed and the wheels-up landing performed by the pilot. The runway light was a contributing factor.NTSB FTW01FA065Accident · 2 fatalField investigationFinal reportBellanca 17-30A · Pampa, TXthe pilot's failure to maintain terrain clearance. Contributing factors were the dark night and the fog.NTSB FTW01FA063Accident · 2 fatalField investigationFinal reportAero Vodochody L-39C · Pecan Island, LAthe pilot's failure to maintain altitude/clearance from terrain while performing low level aerobatics. A factor was fatigue.NTSB CHI01FA085Accident · 1 fatalField investigationFinal reportCessna 152 · Horicon, WIthe inadvertent stall/spin. Additional factors included the aerobatic manuevers, low altitude, and the procedures not followed.NTSB FTW01LA060Accident · Minor injuriesLimited investigationFinal reportCessna 150K · Bishop, TXthe pilot's failure to maintain altitude and clearance from terrain. Contributing factors were the pilot's diverted attention and the low ceiling.NTSB CHI01FA080Accident · 1 fatalField investigationFinal reportBeech 58 · Ainsworth, NEthe pilot's improper in-flight decision to continue flight into known adverse weather. A factor was the icing conditions.NTSB LAX01LA087Accident · 2 fatalLimited investigationFinal reportSutton Tailwind W-8L · Reno, NVThe pilot performed aerobatics at low altitude and failed to maintain clearance from the gound resulting in a collision with the terrain.NTSB CHI01FA077Accident · 2 fatalField investigationFinal reportWatson Steen Skybolt · Camdenton, MOThe pilot not maintaining altitude/clearance from terrain during the low altitude maneuver. Factors were the wind gusts and the low altitude maneuver the pilot performed.NTSB ANC01TA035Accident · No injuriesFinal reportRobinson R-44 · Chickaloon, AKThe pilot's collision with terrain due to his inadequate planning of the approach, and his failure to maintain the helicopter's main rotor RPM during a go-around. Factors in the accident were a tailwind, flat lighting conditions, and snow-covered terrain.NTSB DCA01MA017Accident · 10 fatalClass 1 · MajorFinal reportBeech 200 · Strasburg, COThe pilot’s spatial disorientation resulting from his failure to maintain positive manual control of the airplane with the available flight instrumentation. Contributing to the cause of the accident was the loss of a.c. electrical power during instrument…NTSB CHI01LA075Accident · Serious injuriesLimited investigationFinal reportEnstrom 480 · Dryden, MIThe pilots failure to maintain altitude/clearance from the terrain. The dark night was a factor.NTSB ANC01FA033Accident · 2 fatalField investigationFinal reportDouglas DC-3 · Unalaska, AKThe airplane flightcrew's failure to maintain adequate distance/altitude from mountainous terrain during a departure climb to cruise flight, and the captain's impairment from drugs. Factors in the accident were dark night conditions, and the first officer's…NTSB IAD01LA028Accident · No injuriesLimited investigationFinal reportPiper 34-200T · Bluefield, WVThe pilot's failure to enter the correct altimeter setting, which resulted in continued flight below the decision height and a subsequent collision with trees.NTSB FTW01LA050Accident · Serious injuriesLimited investigationFinal reportCessna 210M · Burnet, TXthe pilot's failure to maintain proper glide path during a practice instrument approach, which resulted in an in-flight collision with terrain. Contributory factors to the accident were the dark night light condition and the safety pilot's inadequate…NTSB NYC01LA065Accident · No injuriesLimited investigationFinal reportCessna 182P · Angola, NYThe pilot's misjudged clearance over an obstacle.NTSB NYC01FA064Accident · 1 fatalField investigationFinal reportCessna 310R · Bluefield, WVThe pilot's failure to execute the published missed approach procedure. A factor was heavy snowfall during the approach.NTSB FTW01LA045Accident · No injuriesLimited investigationFinal reportCessna 152 · Bristow, OKThe pilot's inadequate compensation for the crosswind conditions, which resulted in the airplane striking a snow bank during the landing flare/touchdown. A factor was the crosswind weather condition.NTSB LAX01LA068Accident · No injuriesLimited investigationFinal reportWallace Rotorway Exec 152 · Placerville, CAThe failure of the student pilot to maintain adequate ground clearance while hovering.NTSB CHI01LA054Accident · No injuriesLimited investigationFinal reportCessna 152 · Sturtevant, WIThe unsuitable terrain for landing selected by the student pilot, the inadequate initial training by the flight instructor, and the flight instructor's decision to send the student pilot on a solo flight in known adverse weather conditions. Factors to the…NTSB NYC01FA058Accident · 2 fatalField investigationFinal reportBeech B200 · Rangeley, METhe pilot-in-command's failure to maintain sufficient altitude while maneuvering to land, which resulted in a collision with terrain. Factors in the accident were the dark night, mountainous terrain, snow showers, clouds, and the pilot's decision to cancel…NTSB CHI01LA050Accident · No injuriesLimited investigationFinal reportBeech 58 · Huntingburg, INThe proper touchdown point not obtained/maintained by the pilot. Factors were the snow covered runway, the ice contaminated windshield, and the airport snow removal performed by the driver of the vehicle.NTSB CHI01LA048Accident · Minor injuriesLimited investigationFinal reportSocata TBM 700 · Harrisburg, ILThe pilot not attaining the proper glidepath on the instrument approach. The pilot's decision not to fly to an alternate airport and his decision to continue the approach in weather conditions below the published minimums were contributing factors.NTSB LAX01FA055Accident · 1 fatalField investigationFinal reportCessna TR182 · Petaluma, CAThe pilot's improper IFR procedure, failure to maintain course alignment, and use of a nonapproved handheld GPS receiver for navigation during flight in actual instrument meteorological conditions. Factors contributing to the accident were the low clouds and…NTSB FTW01FA033Accident · 2 fatalField investigationFinal reportCessna 421B · Norman, OKthe pilot's failure to follow the instrument approach procedure and his continued descent below the prescribed minimum descent altitude (MDA). Contributory factors were the pilot's physical impairment from drugs, the low ceiling, fog, and dark night light…NTSB NYC01LA050Accident · 1 fatalLimited investigationFinal reportMiller Slingshot · Kingwood, WVThe pilot's failure to maintain control of the airplane, and subsequent collision with trees.NTSB DEN01FA018Accident · 2 fatalField investigationFinal reportCessna 182P · Taos, NMthe pilot's failure to maintain terrain clearance while maneuvering in a narrow canyon. Contributing factors were the down slope winds in excess of 50 knots and the pilot's improper decision to enter the canyon given the wind conditions.NTSB FTW01LA029Accident · 2 fatalLimited investigationFinal reportLandes/Karich/Schmidt Christen Eagle II · Tyler, TXthe pilot's performance of aerobatic maneuvers at a low altitude and his failure to maintain terrain clearance.NTSB CHI01FA043Accident · 4 fatalField investigationFinal reportPiper PA-28R-180 · Danville, ILThe pilot's failure to maintain altitude/clearance during the instrument approach. Factors were the low ceilings, the pilot's failure to maintain proper alignment and glidepath during the approach, his lack of recent instrument experience, and his failure to…NTSB NYC01FA040Accident · 3 fatalField investigationFinal reportMooney M20K · Rixford, PAThe pilot's loss of control of the airplane while maneuvering. Factors included low ceilings and the pilot's lack of instrument flight experience.NTSB FTW01FA024Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Stillwater, OKthe pilot's failure to maintain altitude/clearance from terrain while performing an instrument approach. Contributing factors were the low ceiling, dark night light condition, the pilot's decision to fly in known adverse weather conditions, and his lack of an…NTSB SEA01FA100Accident · 2 fatalField investigationFinal reportCessna U206F · Cambridge, IDAirspeed not maintained and an inadvertent stall while maneuvering. Mountainous terrain was a factor.NTSB LAX01LA041Accident · 2 fatalLimited investigationFinal reportExperimental Glasair 1RG · Temecula, CAthe pilot's failure to maintain an adequate terrain clearance altitude while performing aerobatic maneuvers, which resulted in the in-flight collision with terrain.NTSB SEA01LA019Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Broadus, MTThe pilot's failure to maintain aircraft control during the takeoff phase of the flight.NTSB DEN01LA007Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Fort Collins, COFailure by the pilot to follow instrument approach procedures and execute a missed approach when the runway environment was not in sight at decision height. A factor was low ceiling.NTSB DEN01FA003Accident · 1 fatalField investigationFinal reportCessna R-182 · Grants, NMthe pilot's continued VFR flight into IMC during cruise. Contributing factors were the dark night light conditions, and the cloudy weather conditions.NTSB CHI01LA007Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Highland, ILthe designated examiner not maintaining clearance from the bank/dike. Factors were the designated examiner's delayed remedial action and the bank/dike.NTSB SEA01LA003Accident · No injuriesLimited investigationFinal reportEnstrom F-28F · Twin Falls, IDThe pilot's failure to maintain adequate rotor rpm. Unsuitable terrain was selected for the maintenance test flight operation.NTSB LAX01FA004Accident · 2 fatalField investigationFinal reportPiper PA-34-200 · San Dimas, CAThe pilots becoming lost and disoriented during an improperly conducted IFR approach, and subsequent missed approach, that led to a collision with rising mountainous terrain. Also causal was the local controller canceling the IFR approach when the pilot…