Skip to content

NTSB investigations: Continental C90 series

1,117 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, newest first

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."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.\"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."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 UNK65X0112Accident · Minor injuriesClosedPiper PA11 · Jasper, MOOct 2, 1964 · N4977H · Substantial damage NTSB UNK64X4206Accident · No injuriesClosedAeronca 7AC · Hamilton, TXSep 29, 1964 · N83538 · Substantial damage NTSB UNK64X4173Accident · No injuriesClosedLuscombe 8F · Waukegan, ILSep 27, 1964 · N1881B · Substantial damage NTSB UNK64X4140Accident · No injuriesClosedLuscombe 8F · Isabella, MNSep 25, 1964 · N1475B · Substantial damage NTSB UNK64X4116Accident · No injuriesClosedChampion 7FC · Milton, FLSep 23, 1964 · N8942R · Substantial damage NTSB UNK64X4114Accident · No injuriesClosedChampion 7FC · Sioux Falls, SDSep 23, 1964 · N9866B · Substantial damage NTSB UNK64X4081Accident · Serious injuriesClosedChampion 7FC · Columbia, ILSep 20, 1964 · N9043B · Destroyed NTSB UNK64X4058Accident · Minor injuriesClosedChampion 7FC · Humacao, PRSep 20, 1964 · N8915R · Substantial damage NTSB UNK64X4022Accident · No injuriesClosedAeronca 7EC · Cavendish, IDSep 17, 1964 · N4317C · Substantial damage NTSB UNK64X3974Accident · No injuriesClosedChampion 7FC · Reynoldsburg, OHSep 13, 1964 · N9868Y · Substantial damage NTSB UNK64X3893Accident · No injuriesClosedErcoupe 415C · Anderson, INSep 10, 1964 · N2700H · Substantial damage NTSB UNK64X3885Accident · No injuriesClosedCessna 140 · El Reno, OKSep 9, 1964 · N2228V · Substantial damage NTSB UNK64X3873Accident · No injuriesClosedChampion 7FC · Santa Barbara, CASep 8, 1964 · N7569B · Substantial damage NTSB UNK64X3825Accident · No injuriesClosedCessna 140 · Burnet, TXSep 6, 1964 · N2340V · Substantial damage NTSB UNK64X3798Accident · No injuriesClosedChampion 7EC · Antioch, CASep 5, 1964 · N9984Y · Substantial damage NTSB UNK64X3747Accident · No injuriesClosedCessna 140A · Fresno, CASep 2, 1964 · N9423A · Substantial damage NTSB UNK64X3658Accident · No injuriesClosedLuscombe 8F · Albuquerque, NMAug 29, 1964 · N1373B · Substantial damage NTSB UNK64X3539Accident · No injuriesClosedChampion 7EC · Susitna Rivr, AKAug 22, 1964 · N9022B · Substantial damage NTSB UNK64X3449Accident · Serious injuriesClosedAeronca 7AC · Plainfield, CTAug 18, 1964 · N33P · Destroyed NTSB UNK64X3406Accident · Serious injuriesClosedPiper J3 · Monroeville, PAAug 15, 1964 · N98679 · Substantial damage NTSB UNK64X3393Accident · No injuriesClosedSilvaire 8F · Cambridge, PAAug 15, 1964 · N9936C · Substantial damage NTSB UNK64X3333Accident · Minor injuriesClosedPiper PA11 · Moscow, IDAug 11, 1964 · N4546M · Destroyed NTSB UNK64X3326Accident · No injuriesClosedChampion 7EC · Mercury, NVAug 11, 1964 · N9099B · Substantial damage NTSB UNK64X3317Accident · No injuriesClosedChampion 7FC · Forest City, IAAug 10, 1964 · N9897B · Substantial damage NTSB UNK64X3172Accident · Minor injuriesClosedPiper PA18 · Yadkinville, NCAug 2, 1964 · N7783D · Substantial damage NTSB UNK64X3152Accident · No injuriesClosedCessna 140 · Van Nuys, CAAug 1, 1964 · N3747V · Substantial damage NTSB UNK64X3125Accident · No injuriesClosedAir Product F1 · Winona, KSJul 30, 1964 · N3052G · Substantial damage NTSB UNK64X3039Accident · No injuriesClosedChampion 7FC · Dayton, OHJul 25, 1964 · N8951R · Substantial damage NTSB UNK64X2895Accident · Minor injuriesClosedLuscombe 8F · Boulder Creek, COJul 18, 1964 · N9933C · Destroyed NTSB UNK64X2842Accident · No injuriesClosedCessna 140 · Daytona Beach, FLJul 15, 1964 · N90174 · Substantial damage NTSB UNK64X2760Accident · No injuriesClosedChampion 7EC · New Ulm, MNJul 11, 1964 · N9878B · Substantial damage NTSB UNK64X2729Accident · Minor injuriesClosedChampion 7FC · Blaine, MNJul 9, 1964 · N7501B · Substantial damage NTSB UNK64X2701Accident · No injuriesClosedCessna 140 · Bowling Green, KYJul 7, 1964 · N2403V · Substantial damage NTSB UNK64X2681Accident · No injuriesClosedChampion 7FC · Kaplan, LAJul 6, 1964 · N4851E · Destroyed NTSB UNK64X2371Accident · No injuriesClosedCessna 140 · Santanta, KSJun 19, 1964 · N2367V · Destroyed NTSB UNK64X2204Accident · No injuriesClosedCessna 140 · Winters, CAJun 9, 1964 · N9428A · Destroyed NTSB UNK64X2149Accident · No injuriesClosedPiper PA11 · Churchs Ferry, NDJun 6, 1964 · N4842M · Substantial damage NTSB UNK64X2103Accident · No injuriesClosedCessna 140 · Hillsboro, VAJun 4, 1964 · N2298V · Substantial damage NTSB UNK64X2096Accident · No injuriesClosedChampion 7FC · West Fargo, NDJun 3, 1964 · N7544B · Substantial damage NTSB UNK64X1939Accident · No injuriesClosedPiper J3 · Mansfield, SDMay 24, 1964 · N70294 · Substantial damage NTSB UNK64X1913Accident · Minor injuriesClosedChampion 7EC · Birchwood, WIMay 23, 1964 · N8912R · Substantial damage NTSB UNK64X1848Accident · No injuriesClosedCessna 182 · Ann Arbor, MIMay 19, 1964 · N3791V · Substantial damage NTSB UNK64X1742Accident · No injuriesClosedChampion 7EC · Stevens Point, WIMay 12, 1964 · N8973R · Substantial damage NTSB UNK64X1694Accident · No injuriesClosedPiper J3 · Minneapolis, MNMay 10, 1964 · N33023 · Substantial damage NTSB UNK64X1656Accident · No injuriesClosedChampion 7FC · Whitefield, NCMay 7, 1964 · N7529B · Substantial damage NTSB UNK64X1614Accident · Minor injuriesClosedChampion 7FC · Tewksbury, MAMay 4, 1964 · N9900Y · Substantial damage NTSB UNK64X1577Accident · Minor injuriesClosedChampion 7FC · Champaign, ILMay 2, 1964 · N8568E · Substantial damage NTSB UNK64X1560Accident · No injuriesClosedAeronca 7FC · Santa Barbara, CAMay 2, 1964 · N9896B · Substantial damage NTSB UNK64X1316Accident · No injuriesClosedChampion 7FC · Miamisburg, OHApr 14, 1964 · N7566B · Substantial damage NTSB UNK64X1279Accident · No injuriesClosedCessna 140A · Burns, ORApr 12, 1964 · N5309C · Substantial damage