Skip to content

NTSB investigations: Continental C90 series, IA

23 cases on aircraft whose registry engine model is Continental C90 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" = 'IA' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17009')) 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\" = 'IA' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17009'))
  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" = 'IA' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17009'))
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 CEN11CA532Accident · No injuriesData collectionFinal reportAlon A-2A · Rolfe, IAThe pilot's decision to execute a precautionary landing to unsuitable terrain.Jul 31, 2011 · N5647F · Substantial damage NTSB CHI03LA157Accident · No injuriesLimited investigationFinal reportCessna 140A · Grinnell, IAThe pilot's inadvertent ground loop. Factors contributing to the accident were the wind gusts and crosswind conditions.Jun 5, 2003 · N5667C · Substantial damage NTSB CHI01LA039Accident · No injuriesLimited investigationFinal reportAeronca 7CCM-200 · Corning, IAThe pilot did not adequately compensate for the wind conditions and the subsequent failure to maintain control of the airplane. Factors associated with the accident were the crosswind, the runway light, and the tree.Nov 18, 2000 · N4706E · Substantial damage NTSB CHI96LA033Accident · No injuriesLimited investigationFinal reportForney F-1 · Estherville, IAthe pilot's failure to maintain directional control of the airplane during the landing. A factor associated with the accident was the crosswind condition.Nov 11, 1995 · N7515C · Substantial damage NTSB CHI92LA051Accident · No injuriesLimited investigationFinal reportLuscombe 8-F · Chapin, IAFailed connecting rod which resulted in a catastrophic engine failure. A factor related to the accident was unsuitable terrain.Dec 11, 1991 · N1871B · Substantial damage NTSB CHI91LA155Accident · No injuriesLimited investigationFinal reportPiper J3 · Creston, IAIcing in the induction air control system.May 11, 1991 · N88441 · Substantial damage NTSB MKC78DCD15Accident · No injuriesClosedCessna 140 · Shenandoah, IAJan 28, 1978 · N72750 · Substantial damage NTSB MKC78FCD06Accident · No injuriesClosedCessna 140 · Ankeny, IAOct 19, 1977 · N2419V · Substantial damage NTSB MKC76FCD22Accident · No injuriesClosedCessna 140 · Des Moines, IADec 6, 1975 · N2465V · Substantial damage NTSB MKC73FCD27Accident · Minor injuriesClosedLuscombe 8F · Blakesburg, IASep 3, 1972 · N2163B · Substantial damage NTSB MKC72DCD20Accident · No injuriesClosedLuscombe 8F · Vinton, IAAug 12, 1971 · N9922C · Substantial damage NTSB MKC71DCD23Accident · Minor injuriesClosedPiper PA-11 · Emerson, IAAug 18, 1970 · N5509H · Substantial damage NTSB MKC70A0033Accident · 2 fatalClosedAlon A-2A · Clear Lake, IADec 15, 1969 · N5646F · Destroyed NTSB MKC69D0327Accident · No injuriesClosedPiper PA-11 · Hampton, IADec 28, 1968 · N4866M · Substantial damage NTSB MKC68D0186Accident · No injuriesClosedPiper PA-11 · Pocahontas, IAAug 19, 1967 · N4985M · Substantial damage NTSB MKC68D0504Accident · No injuriesClosedPiper PA-11 · Terril, IAAug 16, 1967 · N5010H · Substantial damage NTSB MKC68D0005Accident · No injuriesClosedAlon A-2 · Shenandoah, IAJun 4, 1967 · N6588Q · Substantial damage NTSB MKC67D0535Accident · No injuriesClosedAeronca 7EC · Washburn, IAMar 24, 1967 · N4660E · Substantial damage NTSB MKC67D0340Accident · Minor injuriesClosedChampion 7FC · Riceville, IADec 4, 1966 · N9852Y · Substantial damage NTSB MKC67F0015Accident · No injuriesClosedCessna 140 · Des Moines, IAJun 21, 1966 · N3621V · Substantial damage NTSB MKC67D0014Accident · No injuriesClosedCessna 140 · Corning, IAJun 11, 1966 · N76644 · Substantial damage NTSB MKC66D0305Accident · No injuriesClosedAeronca 7FC · Washburn, IAOct 13, 1965 · N9897B · Substantial damage NTSB UNK64X3317Accident · No injuriesClosedChampion 7FC · Forest City, IAAug 10, 1964 · N9897B · Substantial damage