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 BFO95FA033Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Cambridge, MDthe commercial/instrument rated pilot's failure to obtain/maintain adequate altitude/clearance during the initial climb after takeoff. Related factors are the pilot's poor planning/decision making, and the fog.NTSB SEA95LA070Accident · 2 fatalLimited investigationFinal reportQuicksilver MXL2 · Hildale, UTThe pilot's failure to maintain adequate airspeed while banking the airplane. This led to an unrecoverable aerodynamic stall in close proximity to the ground. Factors contributing to the accident are the pilot exceeding the airplane's weight and balance…NTSB LAX95LA131Accident · No injuriesLimited investigationFinal reportCessna 150E · Visalia, CAthe pilot's misjudged landing flare and his improper bounced landing recovery technique.NTSB NYC95LA070Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Wilmington, OHThe pilot's failure to maintain adequate terrain clearance during a go around, which resulted in an inflight collision with a snowbank. A factor is the pilot's delay in initiating a go around.NTSB ANC95LA034Accident · Serious injuriesLimited investigationFinal reportCessna 207A · Ketchikan, AKThe pilot's continued visual flight rules (VFR) flight into instrument meteorological conditions (IMC). Factors in the accident were fog and low ceilings, and a failure of the operator to follow their procedures specified in the company operations manual.NTSB SEA95FA064Accident · 1 fatalField investigationFinal reportMcDonnell Douglas 369E · Lakecreek, ORThe pilot's failure to maintain adequate clearance from the surrounding terrain. A factor was the transmission lines.NTSB BFO95LA030Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Belfast, MEthe student pilot's failure to adequately compensate for wind conditions. A related factor was the presence of high snowbanks along the sides of the runway.NTSB ATL95FA057Accident · 2 fatalField investigationFinal reportCessna 208B · Gainesville, GAThe pilots failure to maintain the minimum descent altitude during the approach. The weather and dark night light condition were factors.NTSB LAX95FA129Accident · 4 fatalField investigationFinal reportPiper PA-23-150 · Oceanside, CAThe pilot's intentional VFR flight into known adverse weather. The low ceiling was a factor.NTSB LAX95FA120Accident · 1 fatalField investigationFinal reportCessna 207A · Kotzebue, AKthe pilot's decision to enter a box canyon area at an altitude inadequate to maintain terrain clearance. The pilot's lack of mountain flying experience was a factor in this accident.NTSB SEA95LA055Accident · Serious injuriesLimited investigationFinal reportAyres S2R-T34AG · Moses Lake, WAThe pilot-in-command's failure to maintain adequate altitude above the terrain. Factors include his diverted attention and attempted maneuver to avoid obstructions.NTSB LAX95LA133Accident · No injuriesLimited investigationFinal reportCessna 172P · Redlands, CAthe pilot's use of an excessive approach speed and glidepath angle and his improper bounced landing recovery technique.NTSB LAX95LA111Accident · No injuriesLimited investigationFinal reportCessna 182C · Novato, CAThe pilot's failure to maintain a proper base leg alignment while flying in the traffic pattern and his misjudged distance and altitude during the approach. A factor which contributed to the accident was the dark nighttime lighting condition which reduced the…NTSB LAX95LA108Accident · 3 fatalLimited investigationFinal reportCessna 182Q · San Francisco, CAan inflight collision with water for undetermined reasons.NTSB SEA95FA048Accident · 2 fatalField investigationFinal reportPiper PA-601P · Tremonton, UTThe pilot's attempt to conduct visual flight into instrument meteorological conditions, and his failure to maintain altitude/clearance with the mountainous terrain. Factors were the clouds, and the dark night.NTSB FTW95FA112Accident · 5 fatalField investigationFinal reportPiper PA-32R-300 · Conroe, TXThe pilot's failure to follow published IFR procedures. Factors were the weather conditions, the dark night, and the pilot's failure to activate the approach lighting system.NTSB LAX95LA087Accident · 1 fatalLimited investigationFinal reportStevens S-8 · Tucson, AZThe pilot's failure to maintain adequate control of the airplane to avoid a collision with the ground.NTSB SEA95FA038Accident · 3 fatalField investigationFinal reportBeech V35 · Moose, WYThe pilot's failure to fly the proper glidepath. A factor was the dark night light conditions.NTSB CHI95DTK01Accident · 1 fatalFinal reportGay RV-4 · Lennox, SDThe pilot's failure to maintain adequate altitude while performing aerobatic maneuvers. The pilot's impairment of judgment and performance due to drugs was a factor.NTSB MIA95LA054Accident · Minor injuriesLimited investigationFinal reportBell 47G · Bunnell, FLThe pilot's failure to maintain altitude while descending over a lake, resulting in an in-flight collision with water.NTSB LAX95FA340Accident · 1 fatalField investigationFinal reportCessna 182B · Rancho Cucamong, CAthe failure of the pilot to maintain adequate altitude above mountainous terrain.NTSB LAX95FA068Accident · 2 fatalField investigationFinal reportGrumman AA-5A · San Luis Obispo, CAthe pilot's intentional flight into an area of known marginal weather conditions during a night cross-country flight and the flight's subsequent inadvertent entry into instrument meteorological conditions at an altitude insufficient to remain clear of the…NTSB SEA95LA035Accident · No injuriesLimited investigationFinal reportCessna 152 · Lehi, UTThe pilot's failure to maintain altitude/clearance above the terrain. Factors include the pilot inadvertently becoming lost/disoriented, his improper inflight decision to attempt to maneuver through unfamiliar mountainous terrain to his original destination,…NTSB SEA95LA033Accident · Serious injuriesLimited investigationFinal reportCessna 182 · Murphy, IDThe pilot's failure to maintain altitude/clearance from the terrain. Factors include a dark night and a strong headwind.NTSB FTW95FA075Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Van Horn, TXThe pilot's failure to maintain proper altitude. Factors were reduced light conditions, clouds, and the pilot's premature descent.NTSB ANC95LA022Accident · No injuriesLimited investigationFinal reportCessna 140 · Tok, AKThe pilot's attempt to fly into known adverse weather. A factor related to the accident was the icing conditions.NTSB LAX95LA060Accident · 1 fatalLimited investigationFinal reportPiper PA-28R-180 · Searchlight, NVthe pilot's intentional continued flight into instrument meteorological conditions in mountainous terrain.NTSB CHI95LA062Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Fort Dodge, IAThe pilot's improper IFR procedure. The low ceiling and fog were a factor.NTSB MIA95LA044Accident · No injuriesLimited investigationFinal reportBell 206B · Miami, FLInadequate supervision by the pilot-in-command (CFI) for failure to note reduction in clearance between the tail rotor and an embankment.NTSB LAX95LA051Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Oasis, CAthe pilot's improper inflight decision by selecting an inadequate terrain clearance altitude over mountainous terrain.NTSB BFO95FA020Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Nesquehoning, PAthe non-instrument-rated pilot's poor in-flight decision to continue VFR flight into instrument meteorological conditions, at night, and his failure to maintain sufficient altitude to ensure clearance from obstructions/terrain. Related factors were the…NTSB ANC95LA017Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Takotna, AKThe pilot's inadequate preflight planning for the departure. A snow covered runway, flat lighting conditions, and a snowbank were factors in the accident.NTSB LAX95FA044Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Groveland, CAthe failure of the pilot to maintain adequate terrain clearance during a nighttime descent into the airport over an unlighted mountainous area. Contributing to the accident was the pilot's distraction by attempting to make several cellular telephone calls…NTSB ANC95LA015Accident · Serious injuriesLimited investigationFinal reportCessna 206 · Angoon, AKThe pilot's continued flight into adverse weather. A factor related to the accident was the snow conditions.NTSB FTW95FA050Accident · 2 fatalField investigationFinal reportCessna 172P · Deming, NMThe pilot's failure to maintain sufficient altitude and clearance in moutainous terrain. Factors were rising terrain and gusty, high wind conditions.NTSB LAX95FA033Accident · 1 fatalField investigationFinal reportSchweizer 269C · Valencia, CAthe pilot's failure to maintain adequate clearance from a dirt embankment while performing an undetermined maneuver.NTSB ATL95FA013Accident · 2 fatalField investigationFinal reportCessna 152 · Dresden, TNThe pilot in command's (CFI) impairment of judgment and performance due to alcohol and drugs, which led to his failure to maintain separation from terrain.NTSB SEA95LA015Accident · No injuriesLimited investigationFinal reportPiper PA-18-105 · Gillette, WYThe pilot in command's failure to maintain clearance with terrain. Factors contributing were the snow covered terrain and low ceiling resulting in poor contrast.NTSB BFO95LA008Accident · Serious injuriesLimited investigationFinal reportAmerican General AA1 · Beach City, OHthe pilot-in-command's failure to maintain adequate control of the aircraft during the takeoff. The pilot's inadequate compensation for unfavorable wind conditions is a related factor in this accident.NTSB SEA95FA011Accident · 4 fatalField investigationFinal reportCessna 310R · Rawlins, WYThe pilot-in-command's not maintaining clearance with terrain. Factors contributing to the accident were high terrain, dark night conditions, and the pilot-in-command's not obtaining/ maintaining the proper climb rate.NTSB FTW95FA030Accident · 2 fatalField investigationFinal reportPiper PA-28-235 · Aurora, COTHE CFI's FAILURE TO MAINTAIN AIRCRAFT CONTROL DUE TO SPATIAL DISORIENTATION. FACTORS WERE: A DARK, MOONLESS NIGHT WITH NO VISIBLE HORIZON AND RECENCY OF NIGHT EXPERIENCE BY THE FLIGHT INSTRUCTOR.NTSB CHI95FA018Accident · 5 fatalField investigationFinal reportPiper PA-23-250 · Sellersburg, INFailure of the pilot to follow IFR procedures by allowing the aircraft to deviate left of the ILS localizer course, by not maintaining the proper ILS glide path, and by continuing descent below the ILS decision height.NTSB CHI95FA012Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Winfield, ILCollision with the ground for an undetermined reason. The pilot's psychological condition was a probable factor.NTSB FTW95LA021Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Albuquerque, NMImproper planning/decision by the pilot, while attempting flight into known adverse weather (wind), and his inadequate compensation for wind conditions. The gusty crosswind conditions and turbulence were related factors.NTSB ATL95FA003Accident · 2 fatalField investigationFinal reportCessna 182L · Ft. Mcclellan, ALThe pilot's continued VFR flight into IMC conditions, and his failure to maintain a proper altitude over mountainous terrain. Factors were the low ceiling, fog, and drizzle weather conditions, and the mountainous terrain at the accident site.NTSB CHI95FA002Accident · 2 fatalField investigationFinal reportPiper PA-18-135 · Martinsville, INThe pilot's impairment of judgment and performance due to alcohol, improper planning/decision, and failure to maintain sufficient altitude/clearance above the ground.NTSB FTW95FA002Accident · Serious injuriesField investigationFinal reportPiper PA-28R-200 · Pagosa Springs, COThe pilot's continued flight into known adverse weather. Factors were the pilot's lack of familiarity with the geographic area, the turbulence and high density altitude.NTSB BFO94LA161Accident · 2 fatalLimited investigationFinal reportHenderson Christen Eagle II · Painesville, OHThe pilot's failure to maintain aircraft control while conducting aerobatic maneuvers. The pilot's overconfidence in his ability was a factor.NTSB BFO94LA162Accident · No injuriesLimited investigationFinal reportChampion 7FC · Sacramento, KYThe pilot's failure to maintain adequate obstacle clearance.NTSB LAX94LA385Accident · No injuriesLimited investigationFinal reportCessna 152 · Fallbrook, CAThe student pilot's inadequate recovery from a bounced landing.