NTSB investigations
1,048 cases where the first occurrence was “On ground/water encounter 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\" = 320) 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" = 320) 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 FTW98LA025Accident · No injuriesLimited investigationFinal reportBeech A36TC · Stratford, TXThe pilot's failure to maintain the proper glidepath with the airplane resulting in the airplane not touching down at the proper touchdown point on the runway. A factor was the unfavorable winds.NTSB MIA97LA252Accident · No injuriesLimited investigationFinal reportCessna A188B · Greenwood, MSThe intentional operation of the airplane from an unsuitable takeoff area by the pilot-in-command and inadvertent rotation of the airplane after encountering rising terrain on the runway.NTSB SEA97LA205Accident · No injuriesLimited investigationFinal reportCessna U206F · Stanley, IDThe pilot's inadequate planning/decision for taking off in the meteorological conditions present at the time. Factors include a high density altitude, gusty winds, downdrafts, and soft terrain in the area of the forced landing.NTSB ANC97LA140Accident · Minor injuriesLimited investigationFinal reportCessna U206F · King Salmon, AKthe pilot's selection of an unsuitable takeoff area. Factors were the sand bar and the pilot's failure to use all available waterway for the takeoff.NTSB FTW97LA333Accident · No injuriesLimited investigationFinal reportCessna 152 · Zavalla, TXthe pilot's improper planning/decision, becoming lost/disoriented during the flight, and selection of unsuitable terrain for an emergency/precautionary landing. Factors relating to the accident were: the hazy weather condition, and rough terrain in the…NTSB ANC97LA125Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Karluk, AKthe pilot's selection of unsuitable terrain for landing. Related factors were: the direct left crosswind, and the soft sand.NTSB MIA97LA236Accident · No injuriesLimited investigationFinal reportCessna 182Q · Butler, ALThe failure of the pilot to maintain directional control during a landing attempt after adding power to recover from a bounced landing.NTSB ANC97LA118Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Circle, AKThe inadequate visual lookout by the pilot, and his selection of a landing area with high vegetation in the landing path. Factors which contributed to the accident were fatigue and the high vegatation.NTSB FTW97LA288Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW-20 · Briggs, TXThe pilot's failure to maintain aircraft control. A factor was the high vegetation on the side of the runway.NTSB CHI97LA237Accident · No injuriesLimited investigationFinal reportCessna 182F · Haviland, KSthe pilot's improper planning/decision and failure to obtain and/or maintain proper runway alignment during a night landing. Factors relating to the accident were: the airplane's inoperative landing lights, the airport's inoperative runway edge lights, and…NTSB LAX97LA233Accident · No injuriesLimited investigationFinal reportCessna 152 · Madera, CAthe student pilot's failure to maintain runway alignment during takeoff.NTSB FTW97LA235Accident · No injuriesLimited investigationFinal reportPiper PA-28RT-201 · Whitewright, TXThe pilot's selection of an unsuitable area for takeoff. A factor was the dirt bank (terrace).NTSB ATL97LA088Accident · No injuriesLimited investigationFinal reportAir Tractor AT-402B · Ridgely, TNThe pilot's inadequate preflight planning in that he failed to account for the high temperature and high density altitude, which resulted in an aerodynamic stall and loss of control. Factors were the tall crops and the ditch.NTSB CHI97LA176Accident · No injuriesLimited investigationFinal reportMaule M5C · Lino Lakes, MNthe flight instructor's inadequate preflight planning/preparation, his the improper lowering of flaps for takeoff, his failure to use a longer available area for takeoff, and his failure to abort the takeoff before there was an insufficient amount of area…NTSB IAD97LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Morgantown, PAThe pilot's improper decision to attempt a landing on and his failure to align with an unlighted runway at night. Factors were the lack of runway lighting and the night light condition.NTSB MIA97LA169Accident · No injuriesLimited investigationFinal reportCessna Wren 182G-460 · Spartanburg, SCthe pilot's inadequate preflight planning/preparation, by failure to survey the takeoff area, and his delay in aborting the takeoff. Upsloping terrain and high vegetation in the takeoff area were related factors.NTSB ANC97LA082Accident · No injuriesLimited investigationFinal reportCessna TU206A · Yakutat, AKthe pilot's selection of unsuitable terrain for landing.NTSB LAX97LA174Accident · No injuriesLimited investigationFinal reportBurkhart Grob 103A · Peoria, AZfailure of the student pilot to maintain proper runway alignment and wing tip clearance from high vegetation beside the runway during landing, and the flight instructor's inadequate supervision of the flight. High vegetation on the runway shoulder was a…NTSB MIA97LA149Accident · No injuriesLimited investigationFinal reportBoeing B75N1 · Huntersville, NCThe pilot's failure to maintain a visual lookout on landing rollout, resulting in an on-ground collision with a known obstacle (ditch) and subsequent nose over.NTSB LAX97LA153Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Healdsburg, CAThe loss of pressure in the landing gear normal brake system for undetermined reasons requiring the pilot to make an intentional ground loop to stop the aircraft.NTSB ANC97LA049Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Kotzebue, AKthe pilot's selection of unsuitable terrain for taxi and takeoff. Soft/snow covered terrain was a related factor.NTSB ANC97LA050Accident · No injuriesLimited investigationFinal reportCessna 170 · Manley Hot Sprn, AKThe pilot's selection of an unsuitable landing area. A factor was the soft snow.NTSB ANC97LA032Accident · No injuriesLimited investigationFinal reportCessna 170A · Willow, AKThe pilot's excessive speed while taxiing. A factor in the accident was flat light conditions.NTSB CHI97LA051Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · St. Ignace, MIthe pilot's failure to maintain proper runway alignment during the takeoff roll. A factor associated with the accident was the snowbank which the airplane contacted.NTSB ANC97LA020Accident · No injuriesLimited investigationFinal reportCessna 140 · Gustavus, AKthe pilot's selection of unsuitable terrain for landing. The soft terrain was a related factor.NTSB ANC97LA018Accident · No injuriesLimited investigationFinal reportCessna 182 · Skwentna, AKthe pilot's selection of an unsuitable area (terrain) for landing. A factor relating to the accident was: excessive snow cover on the airstrip.NTSB FTW97LA081Accident · Minor injuriesLimited investigationFinal reportAerospatiale ATR-42-320 · Houston, TXThe pilot's failure to follow the proper taxi route while taxiing back to the terminal. A factor was the glare radiating from the airport's terminal area.NTSB LAX97LA077Accident · No injuriesLimited investigationFinal reportCessna 140 · Emigrant Gap, CAthe pilot's misjudgment of altitude/clearance while attempting a precautionary landing on a closed, snow covered runway.NTSB LAX97LA045Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Calexico, CAthe pilot's premature lift-off from the runway and his failure to attain adequate airspeed.NTSB SEA97LA028Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Bruneau, IDthe pilot's failure to perform adequate preflight planning to ensure that the aircraft could complete a takeoff in the distance available. Factors relating to the accident included: a short takeoff area, and a dirt bank at the end of the road from which the…NTSB NYC97LA012Accident · No injuriesLimited investigationFinal reportSocata TB 9 Tampico · Laurens, NYthe student pilot's selection of an unsuitable area for a precautionary landing. Factors relating to the accident were: the student becoming lost, the subsequent low fuel condition, and the embankment in the emergency landing area.NTSB CHI97LA022Accident · Serious injuriesLimited investigationFinal reportGalaxy AX8 · Columbia, MOthe pilot's selection of unsuitable terrain for landing. Factors relating to the accident were: the ditch, which was encountered during the landing; and high vegetation, which covered the ditch making it not visible to the pilot.NTSB CHI97LA023Accident · No injuriesLimited investigationFinal reportCessna 150 · Minneapolis, KSthe pilot's selection of unsuitable terrain on which to land the airplane. A factor relating with the accident was: the large rock, which the airplane contacted.NTSB SEA97TA012Accident · Minor injuriesFinal reportGarlick UH-1H · Detroit, ORthe pilot's misjudgement of rotor clearance from the terrain. The proximity of the berm was a related factor.NTSB ANC96LA164Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Aniak, AKThe pilot's failure to remove all snow and ice from the airplane prior to takeoff.NTSB ANC96LA160Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Kotzebue, AKThe pilot's selection of an unsuitable landing area. A factor in the accident was the soft terrain.NTSB LAX96LA337Accident · No injuriesLimited investigationFinal reportCessna 152 · San Carlos, AZthe pilot's decision to attempt a takeoff with the runway lights inoperative, and his failure to maintain runway alignment during an aborted takeoff, after failure of the landing light. Factors relating to the accident were: darkness, inoperative runway…NTSB ANC96LA166Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Chitina, AKThe pilot's selection of an unsuitable landing site. A factor associated with the accident is the rough and uneven landing site.NTSB ANC96LA153Accident · No injuriesLimited investigationFinal reportCessna 170B · Dillingham, AKthe pilot's selection of unsuitable terrain for taxiing.NTSB MIA96TA221Accident · No injuriesFinal reportBell OH-58A · Wetumpka, ALThe student pilot improper use of flight controls (cyclic a nd collective) on a takeoff to a hover, resulting in the helicopter rolling to the right, and the main rotor blade colliding with the ground.NTSB ANC96LA136Accident · No injuriesLimited investigationFinal reportMaule M-4 · Skwentna, AKThe pilot's selection of an unsuitable landing site. A factor associated with the accident was the rough and uneven terrain.NTSB LAX96LA316Accident · No injuriesLimited investigationFinal reportCessna 172F · Ocotillo, CAthe pilot's failure to maintain proper runway alignment. The sun glare and proximity of rocks were related factors.NTSB ANC96LA169Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Northway, AKThe pilot's premature lift-off. A factor associated with the accident was the rough and uneven airstrip.NTSB CHI96LA337Accident · No injuriesLimited investigationFinal reportErcoupe 415-C · Wausau, WIthe pilot's selection of an unsuitable landing area, and his misjudgment of distance and speed, while attempting to minimize the effect of crossing an uneven area on the runway. The uneven runway condition was a related factor.NTSB ANC96LA132Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Dillingham, AKThe pilot's selection of unsuitable terrain for landing. Soft terrain was a factor in the accidentNTSB SEA96LA189Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Ephrata, WAfailure of the pilot to maintain proper alignment with the landing area (driveway) during the landing. Factors relating to the accident were: the selection of an unsuitable area for landing, the reported turbulence during landing, and an encounter with a rock…NTSB MIA96LA206Accident · No injuriesLimited investigationFinal reportGrumman 164A · Marks, MSthe pilot's failure to remain clear of the known high point on runway.NTSB IAD96LA127Accident · No injuriesLimited investigationFinal reportCessna 172 · Midland, OHThe pilot's failure to attain adequate alignment with the runway and to maintain adequate terrain clearance during landing.NTSB ANC96LA107Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKThe pilot's inadequate preflight planning for departure and his selection of unsuitable terrain. Factors in the accident were soft, snow covered terrain and the pilot's delay in aborting the takeoff.NTSB CHI96LA303Accident · No injuriesLimited investigationFinal reportCessna A188B · Watford City, NDthe pilot's failure to maintain directional control while landing on a road.