Skip to content

Final NTSB investigations: Continental 0-300 series, ND

22 cases on aircraft whose registry engine model is Continental 0-300 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

19652026

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 ('17022')) 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 ('17022'))
  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 ('17022'))
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 CEN19LA311Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · Grassy Butte, NDA total loss of engine power due to water contamination of the fuel, and the pilot's failure to conduct a preflight inspection.Sep 10, 2019 · N5347T · Substantial damage NTSB CHI08CA157Accident · Minor injuriesData collectionFinal reportCessna 172C · Nortonville, NDThe pilot's inadequate preflight which resulted in insufficient fuel on board to complete the flight. A factor associated with the accident was the soft terrain encountered during the forced landing.Jun 4, 2008 · N1437Y · Substantial damage NTSB CHI03LA266Accident · No injuriesLimited investigationFinal reportCessna 172G · Bowdon, NDThe pilot's failure to maintain adequate airspeed which led to a stall. Contributing to the accident was the pilot's lack of experience, the crosswind condition, wind gusts and power lines.Aug 16, 2003 · N6057R · Substantial damage NTSB DEN89LA168Accident · Minor injuriesLimited investigationFinal reportCessna 172H · Hatton, NDImproper in-flight planning/decision by the pilot and his failure to maintain sufficient clearance above the ground. The tailwind, high obstruction (shelter belt), and downdraft were contributing factors.Jul 12, 1989 · N3269L · Destroyed NTSB DEN87LA071Accident · No injuriesLimited investigationFinal reportCessna 172H · Larimore, NDThe plt was practicing stop and go landings at an arpt near his home. His passenger was a rated plt. On takeoff the aircraft swerved to the right. The right main gear struck a snow bank and the acft nosed over.Mar 23, 1987 · N1725F · Substantial damage NTSB DEN85LA219Accident · No injuriesLimited investigationFinal reportCessna C-172 · Killdeer, NDThe plt said he measured the length of the r/w prior to t/o. the t/o was normal on a downsloping r/w with trees at the FAR end. The plt said that as the a/c lifted off the r/w the a/c struck the trees. He said a gust of wind caused the a/c to settle into the…Aug 15, 1985 · N7202A · Substantial damage NTSB DEN81FTG18Accident · No injuriesClosedCessna 172 · Bowdon, NDSep 5, 1981 · N7443A · Substantial damage NTSB DEN81DTG05Accident · No injuriesClosedCessna 172 · Oakes, NDDec 18, 1980 · N5692A · Substantial damage NTSB MKC77FTG05Accident · Serious injuriesClosedCessna 172 · Stanton, NDMay 14, 1977 · N7778X · Substantial damage NTSB MKC77FTG02Accident · No injuriesClosedCessna 172F · Driscoll, NDFeb 11, 1977 · N8358U · Substantial damage NTSB MKC73FTG18Accident · No injuriesClosedCessna 172 · Grand Forks, NDJun 4, 1973 · N5596R · Substantial damage NTSB MKC73DTG13Accident · No injuriesClosedCessna 172 · Grace City, NDMay 21, 1973 · N7423A · Substantial damage NTSB MKC73FTG12Accident · No injuriesClosedCessna 172 · Fargo, NDMay 3, 1973 · N1892Y · Substantial damage NTSB MKC72DTG17Accident · No injuriesClosedCessna 172F · Cando, NDJan 16, 1972 · N8567U · Substantial damage NTSB MKC71FDD04Accident · No injuriesClosedCessna 172 · Garrison, NDAug 9, 1970 · N3912L · Substantial damage NTSB MKC69F0262Accident · No injuriesClosedCessna 172 · Cavalier, NDNov 11, 1968 · N1619F · Substantial damage NTSB MKC68F0232Accident · Minor injuriesClosedCessna 172 · Mercer, NDSep 10, 1967 · N8165B · Substantial damage NTSB MKC68F0095Accident · No injuriesClosedCessna 172 · Devils Lake, NDJul 22, 1967 · N6225E · No damage NTSB MKC67F0313Accident · No injuriesClosedCessna 172H · Fargo, NDNov 17, 1966 · N1633F · Substantial damage NTSB MKC67F0128Accident · No injuriesClosedCessna 172 · Gilby, NDJul 31, 1966 · N4124F · Substantial damage NTSB MKC67F0125Accident · No injuriesClosedCessna 172 · Rock Lake, NDJul 31, 1966 · N7423A · Substantial damage NTSB MKC66F0241Accident · No injuriesClosedMaule M-4 · Minot, NDSep 13, 1965 · N4602T · Substantial damage