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 CHI77DEV28Accident · Minor injuriesClosedChampion 7EC · Urbana, ILJun 14, 1977 · N9905Y · Substantial damage NTSB FTW77FRD34Accident · Minor injuriesClosedChampion 7FC · Kinder, LAJun 10, 1977 · N9856Y · Substantial damage NTSB NYC77FNE18Accident · Minor injuriesClosedPiper J3 · Fairfield, CTMay 16, 1977 · N6661H · Substantial damage NTSB DEN73DTE43Accident · No injuriesClosedCessna 140A · Calhan, COMay 14, 1977 · N9694A · Substantial damage NTSB NYC77FGM21Accident · No injuriesClosedAlon A-2 · Beaver Falls, PAMay 7, 1977 · N5470E · Substantial damage NTSB MIA77DKJ31Accident · Serious injuriesClosedPiper J-3 · Mobile, ALApr 16, 1977 · N65881 · Substantial damage NTSB NYC77DFA19Accident · No injuriesClosedCessna 140 · Monticello, NYApr 9, 1977 · N2752N · Substantial damage NTSB LAX77FUM24Accident · No injuriesClosedBellanca 7EC · El Centro, CAApr 5, 1977 · N4341C · Substantial damage NTSB MIA77DLD37Accident · Minor injuriesClosedPiper J-3 · Okeechobee, FLMar 20, 1977 · N92025 · Destroyed NTSB FTW77FRA09Accident · No injuriesClosedAlon A2 · North Zulch, TXFeb 6, 1977 · N5653F · Substantial damage NTSB ANC77DAG33Accident · No injuriesClosedPiper PA-11 · Alexander Ck, AKFeb 5, 1977 · N4987M · Substantial damage NTSB LAX77FUJ22Accident · Minor injuriesClosedForney F-1 · Phoenix, AZJan 21, 1977 · N7561C · Substantial damage NTSB SEA77FTA07Accident · No injuriesClosedPiper PA-18 · Miles City, MTJan 17, 1977 · N2989Z · Substantial damage NTSB SEA77FTA06Accident · No injuriesClosedPiper PA-18 · Glasgow, MTJan 3, 1977 · N5425H · Substantial damage NTSB CHI77DEP05Accident · Minor injuriesClosedCessna 140 · Brookfield, WINov 20, 1976 · N2168V · Substantial damage NTSB NYC77DGM01Accident · Minor injuriesClosedPiper PA-18 · Emporium, PAOct 5, 1976 · N8787D · Substantial damage NTSB SEA77DYI01Accident · No injuriesClosedCessna 120 · Crane, OROct 2, 1976 · N77407 · Substantial damage NTSB NYC76FNC67Accident · No injuriesClosedPiper PA-11 · Cushing, MESep 30, 1976 · N4891M · Substantial damage NTSB CHI76DEE78Accident · No injuriesClosedCessna 140A · Kankakee, ILSep 12, 1976 · N9445A · Substantial damage NTSB OAK76DVD48Accident · No injuriesClosedAeronca 7EC · Eureka, CAAug 20, 1976 · N7567E · Substantial damage NTSB FTW76DPJ43Accident · Minor injuriesClosedAeronca 7FC · Thomas, OKJul 31, 1976 · N8952R · Destroyed NTSB MKC76DER81Accident · No injuriesClosedAeronca 7EC · Olivia, MNJul 19, 1976 · N7592B · Substantial damage NTSB IAD76DIG17Accident · No injuriesClosedAeronca 7CCM · Cumberland, MDJun 8, 1976 · N4635E · Substantial damage NTSB ANC76DAH18Accident · Minor injuriesClosedPiper PA-11 · Cape Seniavin, AKMay 23, 1976 · N4754H · Destroyed NTSB MKC76DER61Accident · Minor injuriesClosedChampion 7EC · Fertile, MNApr 25, 1976 · N9861B · Destroyed NTSB DEN76FTC28Accident · Serious injuriesClosedCessna 140 · Green River, WYApr 4, 1976 · N2378V · Substantial damage NTSB CHI76FEA28Accident · Minor injuriesClosedAeronca 7FC · Lebanon, INMar 11, 1976 · N8951R · Substantial damage NTSB SEA76FTA16Accident · No injuriesClosedPiper PA-11 · Ashland, MTMar 10, 1976 · N5010H · Substantial damage NTSB MKC76FTK19Accident · Serious injuriesClosedPiper PA-18 · Milbank, SDJan 24, 1976 · N6980D · Substantial damage NTSB NYC76FHD16Accident · No injuriesClosedAlon A-2 · Ocean City, NJJan 10, 1976 · N5656F · Substantial damage NTSB CHI76FEV24Accident · No injuriesClosedCessna 140 · Minonk, ILJan 4, 1976 · N3618V · Substantial damage NTSB SEA76FTA10Accident · No injuriesClosedPiper PA-18 · Glasgow, MTDec 23, 1975 · N5425H · Substantial damage NTSB MKC76FCD22Accident · No injuriesClosedCessna 140 · Des Moines, IADec 6, 1975 · N2465V · Substantial damage NTSB LAX76AL030Accident · 2 fatalClosedAlon A-2 · Grapevine, CAOct 27, 1975 · N5682F · Destroyed NTSB ANC76DAG55Accident · No injuriesClosedChampion 7EC · Homer, AKOct 15, 1975 · N9047B · Substantial damage NTSB NYC76DHA14Accident · Minor injuriesClosedCessna 140 · New Milford, PAOct 1, 1975 · N2187V · Substantial damage NTSB MKC76FER28Accident · No injuriesClosedVolmer VJ-22 · Minneapolis, MNSep 22, 1975 · N5918 · Substantial damage NTSB OAK7LDVD06Accident · Minor injuriesClosedChampion 7EC · Petaluma, CAAug 31, 1975 · N9068B · Substantial damage NTSB CHI76DET10Accident · No injuriesClosedAlon A2 · Logansport, INAug 9, 1975 · N5491E · Substantial damage NTSB ANC76DAG20Accident · Minor injuriesClosedChampion 7EC · Gakona, AKAug 4, 1975 · N4671E · Substantial damage NTSB MKC760K001Accident · Minor injuriesClosedBellanca 7EC · Rainy Lake, CanadaJul 21, 1975 · N4370C · Substantial damage NTSB SEA76DYE03Accident · No injuriesClosedLuscombe 8F · Bremerton, WAJul 19, 1975 · N1489B · Substantial damage NTSB ANC76DAG14Accident · No injuriesClosedPiper PA-18 · Anchorage, AKJul 11, 1975 · N1650P · Substantial damage NTSB MKC75DCJ61Accident · No injuriesClosedSmith Mini · Lincoln, NEJun 26, 1975 · N1152 · Substantial damage NTSB LAX75FUG47Accident · Minor injuriesClosedAeronca 7EC · Corona, CAJun 10, 1975 · N8905R · Substantial damage NTSB SEA75DYG40Accident · No injuriesClosedChampion 7FC · Ellensburg, WAMay 30, 1975 · N9093B · Substantial damage NTSB NYC75AN109Accident · 2 fatalClosedAlon A-2 · Vineland, NJMay 23, 1975 · N6562Q · Substantial damage NTSB LAX75DUM26Accident · No injuriesClosedPiper PA-18 · Imperial, CAMay 17, 1975 · N4711A · Substantial damage NTSB IAD75DKW11Accident · No injuriesClosedCessna 140 · Knoxville, TNApr 1, 1975 · N89687 · Substantial damage NTSB CHI75FEC41Accident · Serious injuriesClosedCessna 140 · Mason, MIMar 19, 1975 · N76264 · Substantial damage