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 CHI98LA259Accident · 1 fatalLimited investigationFinal reportAnderson T Craft Special · Pick City, NDThe pilot's failure to maintain sufficient altitude/clearance with terrain. A factor was the pilot's attempted low altitude acrobatic maneuver.NTSB SEA98LA135Accident · No injuriesLimited investigationFinal reportCessna 152 · Miltonfreewater, ORThe pilots failure to maintain proper terrain clearance. Factors contributing to the accident are high density altitude and rising terrain.NTSB SEA98LA132Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5B · Chico Hot Sprgs, MTThe pilot-in-command's selection of the wrong runway for takeoff. Factors contributing to the accident were high density altitude, rising terrain and a fence post.NTSB LAX98LA228Accident · Serious injuriesLimited investigationFinal reportPitts S1-S · Tracy, CAThe failure of the pilot to maintain adequate clearance with the terrain during aerobatic maneuvering.NTSB ANC98FA091Accident · 2 fatalField investigationFinal reportSwearingen SA-26AT · St. George, AKThe pilot-in-command's failure to adequately monitor the instrument approach and the co-pilot's failure to intercept and maintain the proper NDB bearing on the approach. Contributing factors were the pilot-in-command's obstructed view of the NDB indicator and…NTSB SEA98LA119Accident · No injuriesLimited investigationFinal reportCessna 170A · Renton, WAThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. Failure to jettison the external load and downdrafts were factors.NTSB FTW98LA294Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Tulsa, OKThe airplane's impeded climb performance for undetermined reasons. A factor was the rising terrain.NTSB ATL98LA090Accident · Minor injuriesLimited investigationFinal reportMbb Phoebus C · Perry, SCThe pilot's loss of control during takeoff, leading to an in-flight collision with the ground. A factor was the pilot's lack of recent experience in a high performance glider.NTSB FTW98LA278Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Freer, TXThe pilot's failure to maintain tail rotor-ground clearance due to his improper flare while hovering.NTSB SEA98LA107Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Murphy, IDThe pilot's decision to initiate an aborted landing at an airport where, due to the high density altitude, his aircraft was unable to outclimb the rising terrain that surrounded airport. Factors include a high density altitude and crosswinds.NTSB LAX98LA207Accident · Serious injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Skull Valley, AZThe pilot's failure to maintain control of the aircraft while maneuvering at a low altitude.NTSB SEA98FA100Accident · 1 fatalField investigationFinal reportAero Commander 680FL · Helena, MTThe pilot's failure to maintain the correct altitude while turning inbound during a procedure turn to the ILS final approach course. Factors include hilly/mountainous terrain and clouds in the area where the course reversal was performed.NTSB FTW98LA270Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Douglas, WYThe pilot's inadequate judgement in attempting to takeoff from unsuitable rough terrain.NTSB LAX98LA195Accident · 1 fatalLimited investigationFinal reportBlackmore RV-4 · Sedona, AZThe pilot's attempt to perform aerobatics with insufficient terrain clearance altitude available to complete the maneuver. A factor was high density altitude.NTSB SEA98LA093Accident · 1 fatalLimited investigationFinal reportCessna 150 · Amboy, WAThe pilot's failure to maintain adequate altitude and/or clearance from terrain during a go-around attempt. Factors included a short landing area and trees in the landing area.NTSB ANC98LA070Accident · No injuriesLimited investigationFinal reportCessna 185 · Skwentna, AKThe pilot's inadequate compensation for wind conditions. Factors associated with the accident are wind gusts, and a crosswind condition.NTSB ANC98LA068Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Anchorage, AKThe pilot's inadvertent ground loop.NTSB LAX98FA189Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Lytle Creek, CAthe pilot's intentional VFR descent into instrument meteorological conditions, resulting in a collision with mountainous terrain.NTSB SEA98FA090Accident · 2 fatalField investigationFinal reportMaule M-5-220C · Kettle Falls, WAThe pilot's failure to maintain terrain clearance. A factor was an attempt to perform aerobatics at low altitude.NTSB CHI98LA192Accident · No injuriesLimited investigationFinal reportGrumman G164 · Somonauk, ILthe pilot's misjudgment of distance. Factors were wind gusts and crops.NTSB ANC98LA063Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Talkeetna, AKThe pilot's failure to maintain adequate altitude/clearance from rising terrain. A factor associated with the accident was rising terrain.NTSB FTW98FA248Accident · 1 fatalField investigationFinal reportJacob Tussel Everett B1 · Stanley, NMThe pilot's intentional performance of an aerobatic maneuver at an altitude insufficient for a safe recovery.NTSB ANC98TA062Accident · Minor injuriesFinal reportCessna 185 · Kotzebue, AKThe instructor pilot's inadequate compensation for wind conditions. A factor associated with this accident was a downdraft prior to touchdown.NTSB NYC98LA119Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Hanover, PAfailure of the pilot to obtain current information for the divert airfield, and his selection of an unsuitable area for landing. Related factors included: the lower ambient light conditions at dusk, construction on the airfield, and an over-reliance on the…NTSB SEA98FA081Accident · 3 fatalField investigationFinal reportCessna P206C · Dubois, IDAttempted VFR flight into IMC and a loss of aircraft control. An inadequate weather evaluation and drug impairment were factors.NTSB ANC98FA046Accident · Serious injuriesField investigationFinal reportCessna 208 · Nome, AKThe pilot's continued VFR flight into instrument meteorological conditions. Factors in the accident were low ceilings, whiteout conditions, and snow covered terrain.NTSB LAX98LA156Accident · 1 fatalLimited investigationFinal reportBellanca 7GCBC · Gorman, CAThe pilot's failure to maintain airspeed and an inadvertent stall while attempting to reverse direction in low cloud conditions in mountainous terrainNTSB FTW98LA213Accident · No injuriesLimited investigationFinal reportBeech A-36 · Ruidoso, NMInadvertent post departure stall. A factor was high gusty winds.NTSB MIA98FA155Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Fargo, GAthe left engine propeller blades struck the runway surface during takeoff, resulting in the pilot losing control of the airplane, and subsequently impacting with trees.NTSB LAX98FA152Accident · 4 fatalField investigationFinal reportCessna 172N · Avalon, CAThe pilot's failure to maintain adequate altitude/clearance in a Blind/Box Canyon. A related factor was the mountainous/hilly terrain.NTSB FTW98LA205Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402 · Forrest City, ARThe pilot's failure to maintain clearance with terrain. Factors were the sunglare and the pilot's restriction to visibility due to chemicals on the windshield.NTSB FTW98FA203Accident · 1 fatalField investigationFinal reportErcoupe 415-C · Olustee, OKThe student pilot's improper decision to attempt an 180 degree turn to return to the takeoff runway.NTSB ATL98LA073Accident · 1 fatalLimited investigationFinal reportQuad City Ultralight Challenger II · Savannah, GAIn flight collision with terrain for undetermined reasons. A contributing factor was the pilot's lack of familiarity with the aircraft.NTSB ANC98LA042Accident · No injuriesLimited investigationFinal reportCessna 172M · Anchor Point, AKThe pilot's failure to compensate for a crosswind. A related factor was the crosswind.NTSB MIA98LA136Accident · No injuriesLimited investigationFinal reportCessna 150M · Lumber Bridge, NCThe pilot's delay in aborting a takeoff from a wet grass runway.NTSB LAX98LA138Accident · No injuriesLimited investigationFinal reportPorat RAF-200 · Hollister, CAThe failure of the pilot to maintain control of the aircraft. A factor in this accident is the pilot's lack of experience in type aircraft.NTSB IAD98LA046Accident · No injuriesLimited investigationFinal reportLet L-23 · New Castle, VAThe pilot's failure to maintain adequate airspeed during the turn to reverse direction. A factor was his improper use of the speed brake.NTSB SEA98FA101Accident · 2 fatalField investigationFinal reportPiper PA-46-350P · Bigfork, MTThe pilot's failure to maintain terrain clearance for undetermined reasons. Contributing factors were the mountainous terrain, trees, dark night conditions, clouds and pilot fatigue.NTSB MIA98LA126Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Mallards Ldg, GAA deer on the runway which led to the pilot's evasive manuever to avoid the deer.NTSB MIA98LA122Accident · Serious injuriesLimited investigationFinal reportBrock 162F · Canton, GAthe pilot's improper use of throttle and collective pitch during initial takeoff climb, which resulted in a decay of rotor rpm and settling of the helicopter into a lake.NTSB NYC98LA087Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Warren, PAThe pilot's failure to obtain the proper touchdown point.NTSB SEA98FA056Accident · 3 fatalField investigationFinal reportCessna P210N · Royal City, WAAttempted VFR flight into IMC and terrain clearance was not maintained. A low ceiling was a factor.NTSB LAX98LA128Accident · No injuriesLimited investigationFinal reportAir Tractor AT301 · Imperial, CAThe pilot's selection of the wrong runway, which resulted in a downwind takeoff attempt, and, his failure to obtain/maintain a proper airspeed during the takeoff sequence. The aircraft's gross weight and the prevailing density altitude were factors in the…NTSB LAX98LA126Accident · No injuriesLimited investigationFinal reportVictor Marsh Marsh 1 · Lone Pine, CAThe pilot's improper in-flight planning, misjudged terrain clearance, and failure to attain adequate altitude before attempting to traverse the mountain pass. Contributing factors were the high density altitude and the rising, mountainous terrain.NTSB CHI98LA103Accident · Minor injuriesLimited investigationFinal reportCessna 310Q · Council Bluffs, IAthe pilot's failure to maintain proper runway alignment during the landing. The dark night was a factor.NTSB LAX98LA114Accident · Minor injuriesLimited investigationFinal reportSocata TBM 700 · Truckee, CAThe failure of the pilot to maintain control of the aircraft due to spatial disorientation. A factor was the dark night.NTSB LAX98FA112Accident · 2 fatalField investigationFinal reportGough-Herrman Christen Eagle II · Lake Berryessa, CAwas the pilot-in-command's failure to maintain control of the aircraft. Contributing to the accident was the improper altitude.NTSB IAD98GA039Accident · No injuriesFinal reportBell 412 · Quantico, VAthe pilot's failure to maintain adequate altitude/clearance above the terrain and the lack of management oversight of aircrews and equipment.NTSB FTW98LA150Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Ogden, UTthe student pilot not understanding the crew briefing, his premature retraction of the landing gear, and the flight instructor's inadequate supervision of the flight. A factor relating to the accident was: the exchange of unclear information due to the…NTSB LAX98GA110Accident · 1 fatalFinal reportChristen Industries A-1 · Lebec, CAThe trainee-pilot's failure to maintain altitude during a low level turn. Contributing factors were the pilot-in-command's diverted attention inside the airplane, his failure to report the trainee's deficient airplane handling abilities, and the shoulder…