Skip to content

Final NTSB investigations: Continental O-470 series, ND

30 cases on aircraft whose registry engine model is Continental O-470 series. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17026')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17026'))
  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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17026'))
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 CEN26LA214Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Dickinson, NDThe pilot’s failure to maintain aircraft control during landing in gusting wind conditions which resulted in a hard landing.May 28, 2026 · N2056X · Substantial damage NTSB CEN22LA439Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Williston, NDThe pilot's failure to maintain directional control of the airplane during the landing, which resulted in a ground loop.Sep 26, 2022 · N93330 · Substantial damage NTSB CHI06CA156Accident · No injuriesData collectionFinal reportCessna 182N · Cooperstown, NDThe pilot's inadequate compensation for the wind conditions which resulted in a loss of directional control while landing. Factors associated with the accident were the crosswind condition, the high vegetation which the airplane contacted, and the high…Jun 19, 2006 · N9073G · Substantial damage NTSB CHI00LA077Accident · No injuriesLimited investigationFinal reportCessna 182J · Stanley, NDthe pilot's improperly performed flare.Jan 18, 2000 · N3369F · Substantial damage NTSB CHI99LA338Accident · No injuriesLimited investigationFinal reportCessna 182R · Fargo, NDthe pilot misjudged the landing flare which resulted in the airplane porpoising during the landing.Jul 24, 1999 · N9799E · Substantial damage NTSB CHI94LA085Accident · No injuriesLimited investigationFinal reportCessna 182P · Glen Ullin, NDThe delayed application of the carburetor heat by the pilot-in-command. The carburetor icing weather condition was a factor.Feb 11, 1994 · N1794M · Substantial damage NTSB CHI91LA163Accident · No injuriesLimited investigationFinal reportCessna 180 · Devils Lake, NDDirectional control not maintained by the pilot. A factor related to the accident was a crosswind condition.May 26, 1991 · N115F · Substantial damage NTSB CHI91LA024Accident · No injuriesLimited investigationFinal reportCessna 180 · Northwood, NDPoor in-flight planning and decision, unsuitable terrain selected by the PIC.Nov 4, 1990 · N2987C · Substantial damage 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…Aug 29, 1987 · N2413C · Substantial damage NTSB DEN82DA066Accident · No injuriesFinal reportCessna 182P · Enderlin, NDDuring a landing on runway 13, the aircraft veered off the runway after touchdown, then went into a freshly plowed field and nosed over. The pilot estimated that the wind was from 200 degrees at 20 gusting 25 knots. There was a 2640 ft turf runway (04/22) on…Apr 23, 1982 · N1765M · Substantial damage NTSB MKC77FTG06Accident · No injuriesClosedCessna 305A · Minot, NDMay 16, 1977 · N5303G · Substantial damage NTSB MKC74DTG10Accident · No injuriesClosedCessna 182 · Jamestown, NDOct 17, 1973 · N3336F · Substantial damage NTSB MKC74DK009Accident · No injuriesClosedCessna 182 · Hatton, NDJul 29, 1973 · N2352R · Substantial damage NTSB MKC72FTG10Accident · No injuriesClosedCessna 180 · Minot, NDSep 9, 1971 · N709 · Substantial damage NTSB MKC70D0249Accident · Minor injuriesClosedCessna 182 · Edgely, NDNov 6, 1969 · N1913X · Substantial damage NTSB MKC67F0458Accident · No injuriesClosedCessna 182 · Edgeley, NDMar 5, 1967 · N3521U · Substantial damage NTSB UNK67X0105Accident · No injuriesClosedCessna 180 · Strasburg, NDOct 31, 1966 · N4775U · Substantial damage NTSB MKC66D0338Accident · No injuriesClosedCessna 182 · Lisbon, NDDec 8, 1965 · N8575T · Substantial damage NTSB MKC66D0426Accident · No injuriesClosedCessna 182 · Rolette, NDNov 23, 1965 · N8483T · Substantial damage NTSB MKC66F0295Accident · No injuriesClosedCessna 180 · West Fargo, NDNov 9, 1965 · N555F · Substantial damage NTSB MKC66D0185Accident · No injuriesClosedCessna 180 · Mcville, NDJun 25, 1965 · N2192Z · Substantial damage NTSB MKC66F0042Accident · No injuriesClosedCessna 180 · Mapes, NDJun 1, 1965 · N3253D · Substantial damage NTSB MKC65D0151Accident · No injuriesClosedCessna 180F · Nekoma, NDMay 13, 1965 · N2166Z · Substantial damage NTSB MKC66F0030Accident · No injuriesClosedCessna 180 · Williston, NDMay 6, 1965 · N5095E · Substantial damage NTSB UNK65X0267Accident · No injuriesClosedCessna 180 · Langdon, NDOct 13, 1964 · N2110Z · Substantial damage NTSB UNK64X4162Accident · No injuriesClosedCessna 182B · Fargo, NDSep 26, 1964 · N8422T · Substantial damage NTSB UNK64X3743Accident · No injuriesClosedCessna 182 · Stanley, NDSep 2, 1964 · N2100R · Substantial damage NTSB UNK64X3073Accident · No injuriesClosedCessna 180 · Fordville, NDJul 27, 1964 · N2195Z · Substantial damage NTSB MKC66D0051Accident · No injuriesClosedCessna 180F · Petersburg, NDJun 18, 1964 · N2134Z · Substantial damage NTSB UNK64X1752Accident · No injuriesClosedCessna 182 · Edgeley, NDMay 13, 1964 · N5422B · Substantial damage