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 ANC92LA059Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Mccarthy, AKThe pilot's failure to maintain directional control of the airplane. Contributing to the accident were the snow berm and the pilot's lack of total experience in the type of operation (ski equipped airplanes).NTSB CHI92LA125Accident · No injuriesLimited investigationFinal reportBeech K35 · Valley City, NDFailure by airport personnel to remove the snow ridge.NTSB BFO92LA039Accident · No injuriesLimited investigationFinal reportLet L-13 · Lock Haven, PAA tow rope that broke at low altitude.NTSB MIA92LA083Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Kissimmee, FLThe pilot-in-command's failure to attain the proper touchdown point due to landing before the displaced threshold on the rwy.NTSB CHI92LA076Accident · No injuriesLimited investigationFinal reportCessna 414 · Gaylord, MIDirectional control was not maintained by the pilot. Factors related to the accident were: airport snow removal had not been performed by the airport personnel, a dark night with falling snow and the snowbank on the runway.NTSB BFO92FA020Accident · Serious injuriesField investigationFinal reportDouglas DC-9-30 · Horseheads, NYThe aircraft encountered a sudden wind gust during landing flare, which resulted in a hard landing.NTSB LAX92LA071Accident · No injuriesLimited investigationFinal reportCessna 172N · Chandler, AZThe failure of the pilot to maintain an adequate visual lookout while taxiing the aircraft.NTSB CHI92LA055Accident · No injuriesLimited investigationFinal reportAero Commander 690A · Roseau, MNThe pilot's failure to maintain proper alignment with, and not selecting the proper touchdown point on the landing runway. Factors associated with the accident are a dark night light condition and crosswinds.NTSB ATL92LA006Accident · No injuriesLimited investigationFinal reportGrumman G164 · Bay Minette, ALThe rough/uneven runway condition caused by the sink hole.NTSB ATL92LA005Accident · No injuriesLimited investigationFinal reportCessna 182 · Pinson, ALThe failure of the pilot to visually detect and attain proper alignment with the runway.NTSB LAX92LA006Accident · 2 fatalLimited investigationFinal reportBentley Mongoose A · Boulder City, NVThe pilot's selection of an inadequate takeoff area which was too short for the prevailing conditions.NTSB ANC91LA154Accident · No injuriesLimited investigationFinal reportMaule M-5 · Purkeypile Mine, AKThe pilot's improper touchdown point on the gravel bar. Contributing to the accident was the pilot's inattentiveness and the ditch in the gravel bar.NTSB SEA91LA234Accident · No injuriesLimited investigationFinal reportCessna 182A · Grants Pass, ORPilot's selection of unsuitable terrain for a precautionary landing. Factors related to the accident were: motion sickness of the passenger, wet grass runway, the pilot's self-induced pressure to land at the accident airport, and the ditch.NTSB ATL91LA170Accident · No injuriesLimited investigationFinal reportBeech B-33 · Asheville, NCThe pilot's selection of unsuitable terrain for takeoff. Factors were tall wet grass, and the failure of airport personnel to maintain the runway surface.NTSB NYC91LA223Accident · No injuriesLimited investigationFinal reportCessna 150 · Ashland, METhe pilot's premature liftoff. Factors were the rough airstrip and the soft terrain encountered during landing.NTSB LAX91LA362Accident · No injuriesLimited investigationFinal reportSchweizer G164B · Verona, CAThe pilot's improper planning/decision to depart from a runway with high vegetation along the edge and subsequent collision with terrain.NTSB DEN91LA109Accident · No injuriesLimited investigationFinal reportBeech V35 · Byers, COThe pilot's selection of an unsuitable landing site. Factors were: weather conditions and the ditch.NTSB SEA91LA191Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Hamer, IDThe pilot's failure to maintain runway aligment. Factors include high vegetation, and an inadverent ground loop/swerve.NTSB SEA91LA187Accident · Minor injuriesLimited investigationFinal reportBeech A-36 · Kemmerer, WYThe pilot's poor planning/decision. Factors include selecting the wrong runway under the high density altitude conditions.NTSB LAX91LA312Accident · No injuriesLimited investigationFinal reportCessna 172N · Mariposa, CAThe pilot misjudging his planned approach. A down-sloping runway surface was a factor in the accident.NTSB SEA91LA161Accident · No injuriesLimited investigationFinal reportAmerican AA-1A · Sequim, WAThe pilot's failure to maintain directional control during takeoff. Contributing to the accident was a hidden obstruction.NTSB FTW91LA117Accident · Minor injuriesLimited investigationFinal reportThorp T-18CW · Wimberley, TXThe failure of the airport personnel to maintain the airstrip in an operable condition and the pilots failure to maintain runway alignment on touchdown.NTSB CHI91DER12Accident · Serious injuriesFinal reportLacey B D4 · Albert Lea, MNThe pilot's failure to take adequate remedial action. Related factors are the tall grass runway conditions, and the inadequate airspeed.NTSB ATL91LA122Accident · No injuriesLimited investigationFinal reportLearjet 23 · Columbia, TNThe pilot's premature decision to turn off the anti-skid during landing roll. Factors to this accident were hydroplaning conditions.NTSB MIA91LA166Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Doddsville, MSPoor planning decision by the pilot for failure to take into account the temperature extremes and what effect this would have on the ground roll distance. Contributing to the accident was his lack of total experience in the type of operation.NTSB SEA91LA114Accident · No injuriesLimited investigationFinal reportCessna TR182 · Green River, UTWorn brakes. Contributing to the accident was: poor maintenance.NTSB FTW91LA076Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Pioneer, LAThe pilot's use of a runway unsuitable due to recent rains.NTSB CHI91LA141Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · Evansville, WIThe pilot's selection of unsuitable terrain for landing, not maintaining directional control and attempting a go-around without sufficient airspeed. A factor was the rutted runway surface.NTSB CHI91LA143Accident · No injuriesLimited investigationFinal reportCessna 170A · Newell, SDThe pilot's improper aircraft handling.NTSB CHI91LA128Accident · No injuriesLimited investigationFinal reportDe Havilland Beaver U-6A · Oak Island, MNUnsuitable terrain was selected by the pilot. A factor related to the accident was the terrain/runway was composed of weak ice.NTSB LAX91LA167Accident · No injuriesLimited investigationFinal reportCessna 414A · Avenal, CAThe failure of the pilot to maintain directional control after striking a dirt berm during the landing roll. Contributing to the accident was the failure of the pilot to ensure that the airport was adequate for his intended operations.NTSB ATL91LA071Accident · No injuriesLimited investigationFinal reportBeech F33A · Chamblee, GAThe hole in the airport taxiway, which was created by the erosion of soil beneath the taxiway, and the failure of the airport to inspect and maintain ditches which run beneath the runways and taxiways.NTSB ANC91IA037Incident · No injuriesIncident investigationFinal reportBeech C-45H · Shageluk, AKThe accident was the pic's failure to properly determine the required width of runway needed by their airplane and inadequate snow removal. Contributing to the accident was the snow berm and the copilot's misjudgment of runway width.NTSB SEA91LA063Accident · No injuriesLimited investigationFinal reportCessna 120 · Skykomish, WAThe pilot's failure to take appropriate remedial action after landing too FAR down the runway.NTSB ATL91LA057Accident · No injuriesLimited investigationFinal reportCessna 182Q · Brunswick, GAA hidden hole in the runway surface, which was contacted by the nose wheel during the landing roll.NTSB SEA91LA043Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Wolf Point, MTThe inadequate preflight planning and preparation by the pilot in command, and his selection of unsuitable terrain for takeoff. A factor relating to the accident was the snowdrifts in the takeoff area.NTSB ANC91FA019Accident · No injuriesField investigationFinal reportCessna 172G · Wasilla, AKPilot's not removing the frost from the airplane before attempting to takeoff. Contributing to the accident was the pilot's delayed abort, and the berm.NTSB LAX91LA047Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 8-24 · Poway, CAThe pilot's failure to obtain a proper touchdown point. Contributing factors which related to the basket's tipping over were the pilot's misjudging the wind direction and the wind's relative high speed.NTSB DEN91LA009Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Watkins, COThe pilot's inadvertent retraction of the landing gear. A factor was the pilot's lack of familiarity with the airplane.NTSB ATL91LA001Accident · No injuriesLimited investigationFinal reportCessna 172N · Valdosta, GAThe student pilot's failure to maintain directional control during a takeoff attempt. Factors to the accident were the student's overall lack of flight experience, and the reported wind gust.NTSB MIA91LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Rolling Fork, MSThe failure of the pilot to maintain wingtip clearance with tall grass at the edge of the runway during the ground roll.NTSB MIA90LA185Accident · No injuriesLimited investigationFinal reportCessna A188B · Vicksburg, MSFailure of the pilot to avoid a mud hole on the runway during the ground roll to takeoff.NTSB ANC90LA165Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Blair Lakes, AKThe pilot's failure to maintain adequate lookout during the post-landing taxi. Contributing to the accident were the rough terrain, the pilot's lack of total experience, and his lack of familiarity with the geographic area.NTSB ANC90LA162Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-2 · Alagnak River, AKThe pilot-in-command's inadequate preflight planning/preparation, his selection of unsuitable terrain, and his delay in aborting the takeoff.NTSB MIA90LA174Accident · No injuriesLimited investigationFinal reportPitts S1-S · Palm City, FLFailure of the pilot in command to initiate a go around in a timely manner, and the airplane landing gear dug into the soft sod and nosed over.NTSB ANC90LA157Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Kashvik Bay, AKThe pilot-in-command's improper preflight preparation and planning. Contributing to the accident was unsuitable terrain.NTSB CHI90LA219Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Columbus, NEStanding water on the approach end of the runway.NTSB ANC90LA137Accident · No injuriesLimited investigationFinal reportCessna T-207A · King Salmon, AKThe pilot's delay in aborting the takeoff.NTSB SEA90FA149Accident · 1 fatalField investigationFinal reportPiper PA-22-150 · Leavenworth, WAThe pilot's misjudgement in preflight planning when departing toward rising terrain. Contributing factors in this accident were his decision to attempt a climb-out with full flaps extended, and the minimal performance data available to him upon which he could…NTSB CHI90DCD01Accident · No injuriesFinal reportFinn A. Arnold Glassaire/SH-2 · Shenandoah, IAThe failure of the pilot to maintain directional control of the airplane during the takeoff ground run. A factor in the accident is the pilot's lack of total experience in the type of aircraft involved in the accident.