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 ANC96TA092Accident · No injuriesFinal reportHughes 369D · Ketchikan, AKThe pilot's failure to maintain control of the helicopter. The pilot's selection of unsuitable terrain for landing was a factor in the accident.NTSB CHI96LA190Accident · Minor injuriesLimited investigationFinal reportCessna A188B · Oskaloosa, KSfailure of the pilot to maintain proper alignment with the roadway during the takeoff roll. A factor relating to the accident was: the selection of an unsuitable area for takeoff.NTSB CHI96LA161Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Maryville, MOthe pilot's selection of an unsuitable area to taxi off the narrow runway in order to turn around. The proximity of the ditch was a related factor.NTSB SEA96LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Harper, ORthe pilot's selection of unsuitable terrain (landing area) for a precautionary landing. A factor relating to the accident was: the pilot became ill during the flight.NTSB ANC96LA061Accident · No injuriesLimited investigationFinal reportCessna 180 · Hope, AKThe pilot's selection of unsuitable terrain for landing. A factor in the accident was soft terrain.NTSB ANC96LA038Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Palmer, AKthe pilot's selection of an unsuitable area for landing.NTSB ANC96LA036Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Chugiak, AKthe pilot's selection of an unsuitable area for landing.NTSB ANC96LA035Accident · No injuriesLimited investigationFinal reportCessna 206 · Willow, AKthe pilot's selection of unsuitable terrain for landing. Snow covered terrain that concealed uneven terrain was a factor in the accident.NTSB SEA96LA053Accident · No injuriesLimited investigationFinal reportCessna R172K · Garden Valley, IDThe pilot's selection of an unsuitable landing area. The snow covered runway was a related factor.NTSB SEA96LA064Accident · No injuriesLimited investigationFinal reportCessna 180A · Hillsboro, ORthe failure of the pilot to identify the unsuitable taxi area, and the failure of airport maintenance personnel to properly identify a construction area.NTSB LAX96LA320Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Paradise, CAThe pilot's attempted flight into known adverse weather conditions.NTSB FTW96LA087Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Port Mansfield, TXDeer running onto the runway as the student pilot was landing. A factor relating to the accident was: the soft terrain that was encountered as the pilot was maneuvering to avoid a collision.NTSB FTW96LA084Accident · No injuriesLimited investigationFinal reportLearjet 60 · Aspen, COThe pilot's improper in-flight decision to continue with the landing when the runway had not been positively identified. Factors were the snow-covered runway and landing area, sun glare, and the inadequate snow removal by airport personnel.NTSB SEA96LA038Accident · No injuriesLimited investigationFinal reportBeech B100 · Miles City, MTFailure of airport personnel to properly remove snow from the runway or issue an appropriate notam concerning the runway condition. Factors relating to the accident were: the low light condition at dawn, and the snowbank or berm that was left on the runway.NTSB CHI96LA071Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Zionsville, INthe pilot's failure to properly align the airplane for a safe landing on the runway. Related factors were: the pilot's inadequate preflight planning/preparation, snow, the snow-covered runway, and snowbanks on the sides of the runway.NTSB ANC96LA023Accident · No injuriesLimited investigationFinal reportCessna 337G · Stevens Village, AKThe pilot's failure to maintain proper runway alignment during the approach and landing roll. A factor associated with the accident is the reduced visibility created by the falling snow.NTSB SEA96LA032Accident · No injuriesLimited investigationFinal reportCessna 172K · Owyhee, ORthe pilot's selection of unsuitable terrain for landing. The soft terrain and high vegetation were related factors.NTSB CHI96LA058Accident · No injuriesLimited investigationFinal reportCessna 150B · Grant, MIthe pilot's selection of unsuitable terrain and the weak ice-covered runway.NTSB ANC96LA021Accident · No injuriesLimited investigationFinal reportCessna U206G · Selawik, AKThe pilot's inadequate preflight of the airplane by failing to ensure that all the airplane's doors were properly closed. A factor associated with the accident is an open door.NTSB MIA96LA055Accident · No injuriesLimited investigationFinal reportPiper PA-46 · Fort Myers, FLThe failure of the pilot-in-command to maintain directional control. Contributing to the accident was the inadequate amount of rudder input to compensate for engine torque during takeoff.NTSB ANC96LA007Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Girdwood, AKThe pilot's selection of unsuitable terrain for landing. Soft sandy terrain was a related factor.NTSB ANC96LA003Accident · No injuriesLimited investigationFinal reportCessna 180K · Cold Bay, AKthe pilot's selection of an unsuitable area/terrain for landing. The submerged sandbar was a related factor.NTSB ANC95LA176Accident · No injuriesLimited investigationFinal reportCessna 180 · Craig, AKThe pilot's selection of an unsuitable taxi/takeoff area.NTSB ANC95LA171Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Aniak, AKThe pilot's selection of an unsuitable portion of the 6,000 foot long gravel runway for landing. A factor associated with the accident was: the soft gravel berm on the runway.NTSB ANC95LA168Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Kivalina, AKThe pilot's selection of unsuitable terrain for takeoff. A factor relating to the accident was: the rough/uneven terrain.NTSB FTW95LA389Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Salida, COFailure by the pilot to adequately plan the flight and the aircraft altitude capability. Factors are: high altitude, high density altitude, inadequate training in mountain flying, and lack of familiarity with the geographic area.NTSB SEA95LA215Accident · No injuriesLimited investigationFinal reportSocata Rallye 150 ST · Yakima, WAThe pilot's inadequate compensation for wind conditions. The downdraft was a factor.NTSB ANC95LA164Accident · No injuriesLimited investigationFinal reportCessna 180A · Glennallen, AKThe pilot's selection of an unsuitable area for takeoff. The water condition with large waves/swells was a related factor.NTSB FTW95LA378Accident · No injuriesLimited investigationFinal reportMaule M5-210C · Westcliffe, COFailure by the pilot to maintain directional control of the aircraft during taxi. A factor was lack of experience in make and model aircraft.NTSB ANC95LA146Accident · No injuriesLimited investigationFinal reportCessna 180 · Fort Yukon, AKThe pilot's selection of an unsuitable takeoff area.NTSB NYC95LA199Accident · No injuriesLimited investigationFinal reportLet Blanik L-13 · Mayville, NYthe pilot's improper flight control input during the landing roll in high grass, which resulted in a ground loop and subsequent wingtip damage.NTSB ANC95LA144Accident · No injuriesLimited investigationFinal reportCessna 206 · Anchorage, AKThe pilot's inadequate visual lookout for obstacles. The low light condition at dusk was a related factor.NTSB ANC95LA153Accident · No injuriesLimited investigationFinal reportCessna 180 · Nikiski, AKThe pilot's selection of unsuitable terrain for landing. Soft terrain and contamination in the left brake cylinder were related factors.NTSB ANC95LA142Accident · No injuriesLimited investigationFinal reportAeronca 15AC · Glennallen, AKThe pilot's selection of unsuitable terrain for takeoff. High vegetation and upsloping terrain were related factors.NTSB SEA95LA180Accident · No injuriesLimited investigationFinal reportMooney M20A · Rock Springs, WYThe pilot's failure to maintain control of the aircraft. Factors include the uneven runway condition, the information regarding the crowned condition not being disseminated by airport personnel, and the inadequate review/inspection of the condition by FAA…NTSB ANC95LA135Accident · No injuriesLimited investigationFinal reportCessna 172 · Cordova, AKThe pilot's improper planning/decision and delayed decision to abort the takeoff.NTSB ANC95LA134Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Cordova, AKFailure of the pilot to maintain proper alignment with the intended takeoff area during the takeoff roll. Factors relating to the accident were: pilot fatigue and the proximity of rocks/boulders to the takeoff area.NTSB SEA95LA153Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Ogden, UTThe pilot-in-command's failure to maintain directional control. Hte loose tailwheel assembly bolt was a factor.NTSB ANC95LA097Accident · No injuriesLimited investigationFinal reportCessna 180 · Naknek, AKThe pilot's selection of unsuitable terrain for taxi.NTSB ATL95LA126Accident · No injuriesLimited investigationFinal reportCessna A188B · Decatur, ALThe pilot's selection of unsuitable terrain for a precautionary landing. Which resulted in the collapse of the main landing gear. The undetermined aircraft problem and rough/uneven terrain were related factors.NTSB FTW95LA291Accident · Serious injuriesLimited investigationFinal reportQuicksilver Mxlr II · Borger, TXThe pilot's selection of unsuitable terrain for landing and takeoff and failure to maintain flying speed. The soft, uneven terrain and tall grass were factors.NTSB MIA95LA167Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Agricola, MSFailure of the pilot-in-command to maintain clearance between the wing and the corn crop at the edge of the runway during the aborted takeoff from the grass runway.NTSB FTW95LA260Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Mimbres, NMInadequate preflight planning and the selection of unsuitable terrain for takeoff by the pilot-in-command.NTSB CHI95LA203Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Hampshire, ILthe pilot's failure to attain liftoff speed. A factor in the accident was the ditch.NTSB ANC95LA069Accident · No injuriesLimited investigationFinal reportChristen Industries A-1 · Tyonek, AKThe pilot's selection of an unsuitable landing site. A factor associated with the accident is the rough and uneven sandbar.NTSB ANC95LA062Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350-B2 · Skagway, AKThe pilot's selection of unsuitable terrain for landing. Factors in the accident were the uneven and icy terrain.NTSB ANC95LA059Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKThe failure of the pilot-in-command to identify unsafe snow conditions at the site. A factor associated with the accident is the soft snow in the takeoff area.NTSB FTW95LA200Accident · No injuriesLimited investigationFinal reportBeech D55 · Norman, OKThe pilot's inadvertent retraction of the landing gear, resulting in a gear up landing.NTSB ANC95LA046Accident · No injuriesLimited investigationFinal reportDouglas C54GDC · Kivalina, AKThe pilot's failure to identify a hazardous landing area. Factors in the accident are the presence of snow banks/berms on the runway, and the inadequate snow removal by airport personnel.NTSB CHI95LA125Accident · No injuriesLimited investigationFinal reportBell 206B · Horseshoe Bend, MOthe pilot's failure to untie the main rotor tie-down strap prior to starting the helicopter.