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 MIA94LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Hastings, FLThe delayed reaction of the pilot-in-command to compensate for unexpected weather conditions, resulting in damage to the landing gear.NTSB FTW94LA043Accident · Minor injuriesLimited investigationFinal reportBell 412 · Cameron, LAThe copilot's continued flight into adverse weather conditions, and the captain's inadequate supervision. The haze and fog were factors.NTSB NYC94FA029Accident · 2 fatalField investigationFinal reportAerospatiale TB-21 · Lebanon, NHThe pilot's failure to maintain adequate terrain clearance which resulted in an inflight collision with the terrain. A factor was a dark night condition.NTSB DCA94MA022Accident · 18 fatalClass 1 · MajorFinal reportJetstream BA-3100 · Hibbing, MNThe captain's actions that led to a breakdown in crew coordination and the loss of altitude awareness by the flightcrew during an unstabilized approach in night instrument meteorological conditions. Contributing to the accident were: the failure of the…NTSB LAX94LA062Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-300 · Fallon, NVthe pilot's intentional continued flight into known adverse weather conditions.NTSB LAX94LA059Accident · No injuriesLimited investigationFinal reportCessna 150H · Dardanelle, CAThe pilot misjudged the local weather. The wind conditions and the pilot's inability to compensate for the strong downdraft wind conditions were factors.NTSB BFO94LA019Accident · Serious injuriesLimited investigationFinal reportMartin Streak Shadow · Mannington, WVThe pilot's failure to maintain clearance from the surrounding terrain.NTSB SEA94FA034Accident · 1 fatalField investigationFinal reportPiper PA-46-310P · Mountain Home, IDThe pilot's intentional suicide and impairment from consumption of alcohol.NTSB SEA94LA246Accident · 2 fatalLimited investigationFinal reportFlake Talon XP · Estacada, ORFailure of the pilot to maintain sufficient altitude and/or clearance from mountainous terrain. Factors relating to the accident were: the terrain condition and flight into an area with adverse weather and unfavorable winds.NTSB SEA94LA032Accident · No injuriesLimited investigationFinal reportCessna 152 · Seattle, WAThe student pilot failed to flare. His diverted attention was a factor.NTSB CHI94FA036Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Cedar Lake, INthe failure of the pilot to maintain proper altitude. A factor related to the accident was flight into known adverse weather by the pilot.NTSB FTW94FA031Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Longview, TXPoor judgment of the pilot due to impairment from consumption of alcohol and use of a drug (marijuana), and his failure to correct a descent, while maneuvering at low altitude. A factor related to the accident was: the pilot's psychological condition.NTSB CHI94LA034Accident · 1 fatalLimited investigationFinal reportCessna 175 · Hot Springs, SDThe failure of the pilots to maintain sufficient altitude to ensure terrain clearance. Factors which contributed to the accident were: the dark night and rising terrain.NTSB BFO94LA003Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Morrisville, VTThe pilot's lack of experience in soaring which resulted in inadequate altitude to clear the ridge and subsequent collision with the terrain. A related factor was the high terrain.NTSB LAX94LA032Accident · No injuriesLimited investigationFinal reportCessna 172N · Joshua Tree, CAthe pilot's failure to maintain a proper descent rate on final approach. A factor in the accident was the student's limited total experience.NTSB FTW94FA023Accident · 1 fatalField investigationFinal reportBellanca 8KCAB · Saratoga, ARThe pilot-in-command's performance of aerobatics at an altitude where it was not possible to maintain clearance.NTSB MIA94LA013Accident · 3 fatalLimited investigationFinal reportBeech A36 · Ormond Beach, FLPoor judgement of the pilot, due to consumption of alcohol and use of drugs, and his failure (or inability) to maintain altitude (or clearance) above water at night. Darkness was a related factor.NTSB FTW94LA021Accident · 1 fatalLimited investigationFinal reportBell 206B · W. Cameron 240The pilot's failure to maintain proper altitude while maneuvering. Factors were his continued flight into known adverse weather and his self-induced pressure to complete the flight.NTSB ATL94FA010Accident · 1 fatalField investigationFinal reportGrumman American AA-5A · Richmond Hill, GAThe pilot's failure to maintain an adequate altitude above the water. And his physical impairment due to drugs.NTSB MIA94LA012Accident · No injuriesLimited investigationFinal reportCessna 172M · Culebra, PRThe poor in-flight decision of the pilot-in-command to bank the airplane while flying low level instead of climbing to avoid collision with a bird. Contributing to the accident was the pilot's failure to maintain clearance from the water.NTSB ANC94FA011Accident · 1 fatalField investigationFinal reportCessna 207 · Kenai, AKThe pilot's failure to maintain adequate altitude for terrain clearance. Factors which contributed to the accident were: the pilot's lack of usual sleep, the night light condition and hilly terrain.NTSB SEA94FA014Accident · 2 fatalField investigationFinal reportCessna 172P · Kelso, WAThe pilot's failure to follow the published missed approach procedure. Factors in the accident were: the weather and mountainous terrain.NTSB LAX94FA009Accident · 2 fatalField investigationFinal reportNorth American T-6G · Green Valley, CAthe CFI's failure to maintain the proper altitude while flying over mountainous terrain, and his inadvertent flight into instrument weather conditions. Contributing factors were the CFI's improper in-flight decision to fly at the low altitude and his…NTSB NYC94LA008Accident · 1 fatalLimited investigationFinal reportFeatherston Titan Tornado · Mechanicsville, VAFailure of the pilot to correct the descent. Factors related to the accident were: the light conditions at dusk, impairment of the pilot from use of a medication (prescription drug), and possible lack of visual ques (pilot's visual perception).NTSB LAX94FA007Accident · 1 fatalField investigationFinal reportCessna 172N · Sedona, AZthe pilot's decision to continue VFR at an improper altitude into mountainous terrain at night and the inadvertent encounter with clouds along the route. Self-induced pressure due to a low fuel state contributed to the accident.NTSB ANC94LA010Accident · No injuriesLimited investigationFinal reportCessna CE-180 · King Salmon, AKThe pilot-in-command's selection of unsuitable terrain and the berm on the airstrip.NTSB CHI94LA007Accident · Minor injuriesLimited investigationFinal reportBoeing 75N1 · St Paul, MNFailure of the pilot to maintain proper altitude.NTSB ANC94LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Bear Creek, AKThe pilot's delayed go-around procedure. A factor in the accident was the improper use of carburetor heat during the go-around.NTSB SEA94LA003Accident · Serious injuriesLimited investigationFinal reportCessna 180H · Denton, MTThe pilot in command's failure to maintain adequate clearance with terrain. Factors contributing to the accident were unfavorable winds and the pilot in command's inadquate compensation (premature crosswind turn) for the wind conditions.NTSB SEA94FA004Accident · 1 fatalField investigationFinal reportCessna 182P · Heber City, UTThe pilot's improper inflight decisions and failure to maintain proper altitude. Factors include the box canyon.NTSB LAX94FA005Accident · 3 fatalField investigationFinal reportPiper PA-32-300 · Kernville, CAthe pilot's inadvertent flight into a box canyon and his failure to attain a safe altitude. A factor in the accident was the pilot's lack of familiarity with the geographic area.NTSB LAX94FA004Accident · 4 fatalField investigationFinal reportCessna 177RG · Petaluma, CAVFR flight by the pilot(s) into instrument meteorological conditions (IMC), and failure to maintain a proper altitude and/or clearance from terrain, while approaching the destination airport. Factors related to the accident were: the low ceiling and terrain.NTSB FTW94LA001Accident · Minor injuriesLimited investigationFinal reportCessna T188C · New Deal, TXFailure of the pilot to maintain ground clearance while avoiding a powerline. Failure of the pilot to see a second set of power lines prior to initiating the spraying run was also a cause.NTSB ANC94FA001Accident · 1 fatalField investigationFinal reportMaule M-6-235 · Merrill Pass, AKThe pilot-in-command's attempt to fly VFR into IMC conditions. A factor was the whiteout weather condition.NTSB LAX94LA003Accident · 1 fatalLimited investigationFinal reportCessna 182H · Clear Lake Res, CAFailure of the pilot to maintain altitude, while performing a low-altitude maneuver (turn) over water. Factors related to the accident were: sun glare, haze, glassy condition of the water, and the lack of visual cues (visual perception) for the pilot to judge…NTSB CHI93LA376Accident · No injuriesLimited investigationFinal reportCessna 150H · Gary, INan improper climb airspeed established by the pilot-in-command after banner pickup.NTSB CHI93LA377Accident · No injuriesLimited investigationFinal reportLanceair 235M · Rockford, ILThe pilot-in-command delayed aborting the landing. Factors were a wet runway and the pilot-in-command's lack of recent experience in this type of airplane.NTSB SEA93FA206Accident · 1 fatalField investigationFinal reportCessna 180B · Mullan, IDThe pilot's poor in flight decision, and his inadvertent continuation of a VFR flight into instrument meteorological conditions. Factors include low ceilings, snow, fog, rain, and mountainous/hilly terrain.NTSB LAX93FA360Accident · 2 fatalField investigationFinal reportBeech 95-A55 · Pine Mountain, CAThe pilot in command did not maintain adequate clearance with the terrain. Factors in this accident were: the dark night, and the poor in flight planning and decision making by the pilot.NTSB BFO93LA180Accident · No injuriesLimited investigationFinal reportRobinson R22 · Scottdale, PAThe pilot's selection of unsuitable terrain for landing and his delay in performing remedial action.NTSB ATL93LA161Accident · No injuriesLimited investigationFinal reportCessna 152 · Greensboro, NCThe student pilot's inadequate compensation for wind conditions during the touch and go landing. Factors were the crosswind conditions, and the hidden obstruction (rock) in the grass adjacent to the runway.NTSB LAX93LA357Accident · No injuriesLimited investigationFinal reportCessna 210F · Chino, CAthe pilot's inadequate compensation for the downdraft and his failure to maintain the proper glidepath.NTSB BFO93FA178Accident · 1 fatalField investigationFinal reportMaule M-4-210C · Staunton, VAInadequate preflight by the pilot which resulted in inadequate altitude to clear the embankment during the initial climb. Factors in this accident were a tailwind on takeoff and rising terrain at the departure end of the grass airstrip.NTSB ANC93LA185Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Puget Bay, AKThe pilot's improper in-flight planning/decision, and his misjudging his altitude above the water. A factor was the glassy water.NTSB ANC93LA177Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mosquito River, AKThe pilot's failure to maintain a proper altitude during the low pass. A factor was the rough/uneven terrain.NTSB ANC93LA174Accident · 1 fatalLimited investigationFinal reportCessna 206 · Swikshak Bay, AKThe pilot-in-command's failure to attain a proper climb rate.NTSB SEA93LA196Accident · 1 fatalLimited investigationFinal reportAerospatiale SA-365-N2 · Ogden, UTThe pilot's failure to maintain proper altitude. A factor to the accident was glassy water.NTSB LAX93LA348Accident · Minor injuriesLimited investigationFinal reportRobinson R22B · Floriston, CAthe flight instructor's failure to maintain main rotor RPM after initiating a go-around from a pinnacle approach. A factor in the accident was the high density altitude condition.NTSB ANC93FA172Accident · Serious injuriesField investigationFinal reportInterstate S-1B2 Arctic Tern · Talkeetna River, AKThe pilot in command's improper preflight planning. Factors in the accident were: the rough/uneven takeoff location, the excess weight of the airplane, the inadequate design of the add-on tank by the manufacturer affecting the weight and balance, and the…NTSB MIA93LA189Accident · No injuriesLimited investigationFinal reportFerrie Ferri Exec · Delray Beach, FLThe pilot-in-command's improper use of the flight controls (cyclic and collective) during a simulated autorotation, resulting in an in flight collision with terrain and subsequent roll over.