Final NTSB investigations, ND
14 cases where the first occurrence was “On ground/water encounter with terrain/water”.
Cases per year
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2003 | 1 |
| 2006 | 1 |
Where
Open the mapLatest cases
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.\"eventStateOrRegion\" = 'ND' AND c.\"eventCountry\" = 'USA'
AND c.\"completionStatus\" = 'Completed'
AND 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."eventStateOrRegion" = 'ND' AND c."eventCountry" = 'USA' AND c."completionStatus" = 'Completed' AND 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 CHI07CA019Accident · No injuriesData collectionFinal reportAviat S2B · Larimore, NDThe pilot's failure to maintain proper alignment with the runway which resulted in the airplane nosing over. A factor associated with the accident was the soft terrain encountered.NTSB CHI03LA215Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · Esmond, NDThe obstruction of the windshield by the application chemical restricting the pilot's visual lookout, and the pilot's failure to perform an aborted takeoff. Factors contributing to the accident were the leak in the hopper lid and the drainage ditch.NTSB CHI98LA222Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer 164B · Hatton, NDthe delayed abort by the pilot, the overweight condition of the airplane, and the pilot's inadequate preparation prior to takeoff. Factors contributing to this accident were the wet condition of the airstrip, the hopper dump valve not working, and the road…NTSB CHI96LA303Accident · No injuriesLimited investigationFinal reportCessna A188B · Watford City, NDthe pilot's failure to maintain directional control while landing on a road.NTSB CHI93LA318Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Minto, NDThe pilot's failure to maintain adequate aircraft control during ground maneuvering. Inadequate visual outlook by the pilot and the pilot of the other aircraft was a contributing factor.NTSB CHI92LA125Accident · No injuriesLimited investigationFinal reportBeech K35 · Valley City, NDFailure by airport personnel to remove the snow ridge.NTSB DEN89LA066Accident · No injuriesLimited investigationFinal reportCessna 172RG · Larimore, NDInadequate supervision by the flight instructor. Factors related to the accident were: failure of the student pilot to attain a proper touchdown point, his delay in configuring the aircraft & executing the go-around, icy/snowy runway conditions, and the…NTSB DEN87LA228Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Grassy Butte, NDN2413C, a Cessna 180, was landing in teddy roosevelt national park where the plt and his passengers intended to hunt deer. A flat, Grassy area on a ridge was selected for landing. The area was checked and marked off by friends of the plt before the landing…NTSB DEN86LA255Accident · No injuriesLimited investigationFinal reportBeech B58 · Fargo, NDThe pilot stated that during the landing roll he inadertently retracted the landing gear along with the flaps.NTSB DEN85LTG07Accident · No injuriesFinal reportAeronca 058B · Mott, NDWhile departing a stubble field, the aircraft's tire ran into a soft spot in the ground and the aircraft turned and struck the shoulder of a road. The right gear broke and the right wing tip struck the ground, the right strut broke, the tail wheel and rudder…NTSB DEN85LTG05Accident · No injuriesFinal reportGrumman G164A · Colfax, NDThe plt noticed the spray pump was stuck in the off position shortly after takeoff for the aerial application flt. The decision was made to land on a private strip and during landing on the soft fld, the acft contacted high vegetation and nosed down.NTSB DEN84LA206Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Wyndmere, NDSod was worn from the middle of the strip & the strip was wet. Therefore, the plt elected to use the left side of the sod strip for takeoff. During the takeoff roll, the left spray boom dragged into wheat that was growing beside the rwy & the acft veered…NTSB DEN84LA015Accident · No injuriesLimited investigationFinal reportLuscombe 8E · Oakes, NDAfter a brief stop at oaks, ND, for fuel, the plt took off to fly about 5 mi to his private strip in an alfalfa field. During the landing roll, the gear hit a gopher mound & the acft nosed over.NTSB DEN82DA058Accident · No injuriesFinal reportMooney M20F · Crosby, NDThe pilot reported that the runway had a 6 to 7 ft snowbank on the left side of the runway and a 2 to 3 ft snowbank on the right side. Also, water was on the runway intermittently along the entire length. After landing, the plane started hydroplaning. As the…