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 LAX94LA250Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Suisun City, CAundetermined.NTSB LAX94LA244Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8 · Acton, CAthe pilot's improper in-flight planning and his misjudging the wind speed information. Contributing factors were the gusty winds and the lack of suitable terrain.NTSB CHI94LA193Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Levant, KSThe pilot's inadequate evaluation of weather conditions associated with known thunderstorm activity. Factors were the thunderstorm and downdrafts.NTSB SEA94FA129Accident · 3 fatalField investigationFinal reportCessna 182B · Rock Springs, WYAn excessive descent rate in the turn from base to final. Factors include a dark night, high winds, and the pilot's fatigue from his flight and ground schedule the day of the accident.NTSB FTW94FA183Accident · 2 fatalField investigationFinal reportCessna 320E · Battle Mountain, NVThe pilot's failure to maintain terrain clearance while maneuvering during a low level aerial mapping flight. A factor was the box canyon.NTSB SEA94FA123Accident · 2 fatalField investigationFinal reportBellanca 8GCBC · Challis, IDThe pilot's failure to maintain clearance from terrain.NTSB FTW94LA174Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Stuttgart, ARWas the pilots failure to maintain terrain clearance.NTSB ATL94LA104Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Memphis, TNThe pilot's failure to maintain clearance from the earthen dike during the swath run.NTSB FTW94LA159Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · De Witt, ARA stall/mush into terrain after the pilot inadvertently raised the flaps.NTSB FTW94LA185Accident · No injuriesLimited investigationFinal reportCessna 195 · Ama, LAThe pilot-in-command's failure to maintain adequate airspeed above the aerodynamic stall speed.NTSB LAX94FA212Accident · 1 fatalField investigationFinal reportPiper PA-28R-201T · La Verne, CAThe pilot's selection of a flight route and en route descent altitude insufficient to maintain adequate terrain clearance. Factors which contributed to the accident were: the dark night light condition and the mountainous terrain.NTSB SEA94FA111Accident · Serious injuriesField investigationFinal reportCessna TU206G · Gold Bar, WAElectrical system short. Factors to the accident were: mountainous terrain and procedures/directives not followed.NTSB CHI94LA151Accident · No injuriesLimited investigationFinal reportAeronca 11 AC · Carmi, ILpoor preflight planning/preparation. Factors associated with the accident were the high vegetation (grass) and the ditch.NTSB BFO94FA071Accident · 4 fatalField investigationFinal reportBell 412/SP · Bluefield, VAThe pilot's failure to intercept the final approach course, and his improper execution of the instrument approach procedure. Factors which contributed to the accident were: the weather conditions, and the failure of the air traffic controller to adequately…NTSB CHI94LA139Accident · No injuriesLimited investigationFinal reportCessna 172K · Howes, SDThe diverted attention of the pilot-in-command and his failure to maintain proper altitude.NTSB MIA94LA120Accident · No injuriesLimited investigationFinal reportPitts S1-C · Lakeland, FLThe pilot-in-command's failure to maintain proper runway alignment during a crosswind landing.NTSB FTW94FA121Accident · 1 fatalField investigationFinal reportAir Tractor AT-502 · Hughes, ARWas the pilot's failure to maintain terrain clearance for undetermined reason.NTSB FTW94LA118Accident · 1 fatalLimited investigationFinal reportAyres S2R-T34 · Elaine, ARThe pilot's failure to maintain terrain clearance.NTSB CHI94FA113Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Chesterfield, MOsuicide by the pilot.NTSB ANC94GA041Accident · Minor injuriesFinal reportGrumman G21A · Mt. Fairweather, CanadaThe pilot's improper decision in attempting to outclimb the rising terrain with the existing airplane climb performance. Factors which contributed to the accident were: the pilot's inadequate preflight of the airplane, the over maximum gross weight of the…NTSB LAX94FA171Accident · 2 fatalField investigationFinal reportCessna 206 · Show Low, AZthe pilot's intentional VFR flight into known adverse IMC weather conditions. Inadequate preflight planning, dark night operations, and weather conditions that included low ceilings and mountain obscuration were factors in the accident.NTSB FTW94LA103Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140B · Montrose, COThe pilot's failure to maintain clearance.NTSB FTW94FA101Accident · 4 fatalField investigationFinal reportCessna 172RG · Dulce, NMFailure by the pilot in command to properly plan the flight and calculate performance data.NTSB FTW94FA104Accident · 1 fatalField investigationFinal reportBeech 95-B55B · Battlement Mesa, COImpaired judgement and performance of the pilot by flying while under the influence of alcohol that resulted in his failure to maintain clearance (or altitude) from terrain, while flying at night.NTSB CHI94LA106Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Sublette, KSthe commercial pilot's failure to maintain clearance from terrain. Related factors are sun glare and rising terrain.NTSB LAX94LA160Accident · 1 fatalLimited investigationFinal reportAmerican Champion 8KCAB · Marana, AZThe pilot's delayed pullout from a vertical aerobatic maneuver for undetermined reasons.NTSB ANC94LA039Accident · No injuriesLimited investigationFinal reportCessna 170B · Chugiak, AKThe pilot-in-command's improper inflight decision making. Factors contributing to the accident were the mountainous terrain and the downdraft weather conditions.NTSB LAX94FA149Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Frazier Park, CAthe pilot's failure to select a cruise altitude which would ensure adequate terrain clearance. Contributing factors related to the dark, nighttime condition and to the pilot's lack of attentiveness.NTSB LAX94FA138Accident · 2 fatalField investigationFinal reportCessna 150L · San Jacinto, CAThe pilot's impairment of judgment and performance due to alcohol and drugs, which led to his improper planning/decision, and his failure to maintain altitude/clearance from mountainous terrain, while maneuvering at low altitude.NTSB BFO94LA050Accident · No injuriesLimited investigationFinal reportBeech 400 · Cleveland, OHThe pilots failure to use the proper radio frequency to activate the airport runway lights, and the pilot's improper decision to continue his approach and land without the runway lights being on.NTSB SEA94LA064Accident · Minor injuriesLimited investigationFinal reportHiller-Soloy H-23D · Seaside, ORThe pilot's improper use of flight controls resulting in settling with power.NTSB BFO94LA047Accident · No injuriesLimited investigationFinal reportCessna 172M · Slatington, PAThe pilot's inadequate compensation for wind conditions and failure to maintain alignment with the runway. The crosswind was a factor.NTSB BFO94LA045Accident · Minor injuriesLimited investigationFinal reportPiper PA-31T · Norwood, MAThe pilot's failure to attain alignment with the centerline of the runway, and his failure to execute a missed approach. Factors which contributed to the accident were: the dark night, the pilot's improper decision to initiate the approach in below-minimum…NTSB LAX94FA125Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Lake Tahoe, CAThe pilot's impairment of judgment and performance due to drugs, which led to his failure to follow the recommended departure procedure, and his failure to maintain sufficient altitude/clearance from rising mountainous terrain. Factors related to the accident…NTSB CHI94FA080Accident · 1 fatalField investigationFinal reportCessna 320F · Goshen, INthe pilot-in-command's continued operation with known deficiencies in equipment. Factors were ice on the windshield and the pilot-in-commands visual outlook not possible.NTSB ATL94FA047Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Murphy, NCThe failure of the pilot to maintain clearance from the terrain. Factors in the accident were the dark night, and the mountainous terrain.NTSB MIA94FA067Accident · 2 fatalField investigationFinal reportPiper PA-32RT-300 · Sugarloaf Key, FLWas the failure of the pilot-in-command to perform a visual lookout and maintain his altitude. Contributing to the accident was the dark night, over water, visual descent.NTSB BFO94LA036Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Newburyport, MAThe pilot not maintaining clearance from the snowbank during final approach. A factor in this accident was the proximity of the snowbank to the active runway.NTSB FTW94LA075Accident · Serious injuriesLimited investigationFinal reportCessna T-210J · Hobart, OKThe pilot's continued VFR flight into IMC. Factors were the weather, the pilot's failure to obtain a weather briefing for the flight, and the dark night conditions.NTSB LAX94LA101Accident · 1 fatalLimited investigationFinal reportAviat Christen Eagle II · Ramona, CAA failure of the pilot-in-command to maintain an adequate visual lookout and proper altitude to avoid colliding with rising terrain.NTSB SEA94FA052Accident · 1 fatalField investigationFinal reportPiper PA-12 · Idaho Falls, IDThe pilot's failure to maintain clearance from the terrain. Factors include the pilot's poor inflight decision to attempt low level maneuvers in a narrow canyon.NTSB LAX94LA099Accident · Serious injuriesLimited investigationFinal reportGrumman G-164A · Davis, CAwas that the pilot misjudged the airplane's altitude during the swath run.NTSB LAX94LA098Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Borrego Springs, CAThe pilot's intentional decision to abandon the airplane and allow it to fly unattended.NTSB MIA94LA051Accident · No injuriesLimited investigationFinal reportRobinson R-22 · Miami, FLThe pilot-in-command's improper supervision of an unqualified pilot while maneuvering at a low altitude. This resulted in a loss in rotor rpm due to improper flight control input (upward collective pitch), and subsequent in-flight collision with terrain.NTSB MIA94LA039Accident · Minor injuriesLimited investigationFinal reportGrumman G-44A · Leesburg, FLThe pilot misjudged his altitude over glassy water during landing and inadvertently touched down in a flat attitude.NTSB SEA94FA040Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Spokane, WAThe pilot's failure to maintain proper alignment with the instrument landing system approach course. The pilot's failure to perform a missed approach was a factor.NTSB NYC94LA049Accident · 3 fatalLimited investigationFinal reportMooney M20J · Jones Beach, NYwas the pilot's failure to maintain control of the airplane, resulting in the airplane impacting with the water. Also casual in this accident was the pilot's total lack of experience in this type of aircraft, and operations. A factor in this accident was the…NTSB CHI94FA048Accident · 2 fatalField investigationFinal reportPiper PA-32R-300 · Antigo, WIthe failure of the pilot in command to maintain proper altitude.NTSB CHI94LA045Accident · Serious injuriesLimited investigationFinal reportCessna 210B · Dubuque, IAFlight by the pilot into known icing conditions, which resulted in airframe icing and an inability of the aircraft to maintain altitude on the ILS glidepath, once the landing gear was lowered. The weather conditions were related factors.NTSB CHI94LA044Accident · Serious injuriesLimited investigationFinal reportBeech 23 · Denison, IAThe pilot-in-command's inadequate remedial action. A factor associated with the accident is the student pilot's inadequate aircraft handling.