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 MKC75DER54Accident · No injuriesClosedChampion 7EC · Northfield, MNMar 4, 1975 · N4837E · Substantial damage NTSB SEA75DTI21Accident · No injuriesClosedCessna 140A · Deer Lodge, MTFeb 27, 1975 · N1141D · Substantial damage NTSB MKC75DTK12Accident · No injuriesClosedPiper PA-18 · Milbank, SDFeb 2, 1975 · N6980D · Substantial damage NTSB MKC75D1G16Accident · No injuriesClosedPiper J3C-65 · Esmond, NDDec 22, 1974 · N98755 · Substantial damage NTSB LAX75DUM11Accident · Minor injuriesClosedPiper PA-18 · Imperial, CANov 25, 1974 · N4711A · Substantial damage NTSB FTW75FRG36Accident · No injuriesClosedCessna 140A · Port Lavaca, TXNov 10, 1974 · N9650A · Substantial damage NTSB LAX75AL024Accident · No injuriesClosedBell 47G-5 · Riverside, CANov 4, 1974 · N7081J · 2 aircraft · Substantial damage NTSB NYC75FNA23Accident · No injuriesClosedLuscombe 8F · Block Island, RIOct 24, 1974 · N37087 · Substantial damage NTSB IAD75FID06Accident · Minor injuriesClosedChampion 7FC · Martinsville, VASep 28, 1974 · N7591B · Substantial damage NTSB CHI75FET07Accident · No injuriesClosedAeronca 7EC · Demotte, INSep 22, 1974 · N1536E · Substantial damage NTSB MKC75DER22Accident · No injuriesClosedAeronca 7CCM · Alexandria, MNSep 3, 1974 · N4642E · Substantial damage NTSB MKC75DCJ25Accident · No injuriesClosedAlon A2-A · Harrisburg, NEAug 31, 1974 · N5647F · Substantial damage NTSB SEA75FTA06Accident · Serious injuriesClosedPiper PA-11 · Hammond, MTAug 19, 1974 · N4992H · Substantial damage NTSB OAK75AP007Accident · 2 fatalClosedChampion 7FC · Newman, CAAug 17, 1974 · N7584E · Destroyed NTSB DEN75DTE09Accident · No injuriesClosedLuscombe 8F · Del Norte, COJul 29, 1974 · N3545G · Substantial damage NTSB MKC75DTG03Accident · No injuriesClosedPiper PA-11 · Maddock, NDJul 13, 1974 · N5573H · Substantial damage NTSB MKC74FER65Accident · No injuriesClosedAeronca 7EC · Silver Bay, MNJun 29, 1974 · N2139E · Substantial damage NTSB MIA74FKG88Accident · No injuriesClosedErco 415-E · Stockbridge, GAJun 25, 1974 · N94770 · Substantial damage NTSB SEA74DYC60Accident · No injuriesClosedMooney M10 · Lebanon, ORJun 23, 1974 · N9515V · Substantial damage NTSB OAK75DVD38Accident · No injuriesClosedCessna 140 · Hayward, CAJun 23, 1974 · N76138 · Substantial damage NTSB MIA74DLG38Accident · No injuriesClosedAeronca 7AC · Bennettsville, SCJun 23, 1974 · N1664E · Substantial damage NTSB MKC74DER66Accident · No injuriesClosedPiper PA-18 · Fergus Falls, MNJun 18, 1974 · N7071B · Substantial damage NTSB OAK74DVA72Accident · No injuriesClosedAlon A-2 · Fresno, CAJun 8, 1974 · N6366V · Substantial damage NTSB MIA74DLD90Accident · No injuriesClosedPiper J-3 · Lake Placid, FLJun 5, 1974 · N98576 · Substantial damage NTSB LAX74DUM34Accident · No injuriesClosedCessna 140 · Borrego Spg, CAMay 30, 1974 · N2286V · Substantial damage NTSB NYC74FGT18Accident · Minor injuriesClosedForney F-1 · Shippensburg, PAApr 28, 1974 · N3003G · Substantial damage NTSB LAX75DUJ55Accident · No injuriesClosedForney F-1A · Mcneal, AZApr 27, 1974 · N3031G · Substantial damage NTSB CHI74DEM58Accident · No injuriesClosedChampion 7FC · Lansing, MIApr 26, 1974 · N7539E · Substantial damage NTSB MIA74FLD81Accident · Minor injuriesClosedForney F-1 · Sanford, FLApr 25, 1974 · N7526C · Substantial damage NTSB MIA74FLD81Accident · No injuriesClosedCessna 140 · St.Cloud, FLApr 7, 1974 · N2582N · Substantial damage NTSB IAD74DLQ19Accident · No injuriesClosedAeronca 7FC · Falmouth, KYApr 7, 1974 · N8952R · Substantial damage NTSB OAK74FVW16Accident · Minor injuriesClosedChampion 7EC · Lone Pine, CAApr 6, 1974 · N4341C · Substantial damage NTSB SEA74DYA22Accident · No injuriesClosedLuscombe 8F · Cascade, IDFeb 9, 1974 · N1391B · Substantial damage NTSB MKC74FCG14Accident · Minor injuriesClosedLuscombe T8-F · Lenexa, KSNov 22, 1973 · N1824B · Substantial damage NTSB CHI74FEV26Accident · No injuriesClosedAeronca 7EC · Monticello, ILNov 5, 1973 · N85547 · Substantial damage NTSB ANC74DAG72Accident · No injuriesClosedPiper PA-11 · Alexndr Lake, AKNov 4, 1973 · N4987M · Substantial damage NTSB NYC74FHA14Accident · No injuriesClosedErco 415-D · Tunkhannock, PAOct 20, 1973 · N2396H · Substantial damage NTSB LAX74FUM10Accident · No injuriesClosedPiper PA-18 · Santee, CAOct 19, 1973 · N7248K · Substantial damage NTSB FTW74DPA10Accident · Minor injuriesClosedPiper PA-11 · Waxahachie, TXOct 7, 1973 · N4927H · Substantial damage NTSB FTW74DRJ16Accident · No injuriesClosedLuscombe 8F · Kilbourne, LAOct 1, 1973 · N2129B · Substantial damage NTSB SEA74DYE11Accident · No injuriesClosedCessna 140A · Tacoma, WASep 7, 1973 · N5396C · Substantial damage NTSB NYC74DNA13Accident · No injuriesClosedPiper J-3 · Greene, RISep 1, 1973 · N6987H · Substantial damage NTSB MKC74DER43Accident · Minor injuriesClosedPiper PA-18 · Intl Falls, MNAug 18, 1973 · N5415H · Substantial damage NTSB ANC74GAG10Accident · No injuriesClosedPiper J3 · Wasilla, AKJul 22, 1973 · N70656 · Substantial damage NTSB SEA74FYE02Accident · No injuriesClosedChampion 7EC · Tacoma, WAJul 4, 1973 · N7439B · Substantial damage NTSB OAK74FVG01Accident · Serious injuriesClosedCessna 140 · Grass Vally, CAJul 1, 1973 · N2392V · Substantial damage NTSB CHI73DEP69Accident · No injuriesClosedCessna 140A · Milwaukee, WIJun 29, 1973 · N1116D · Substantial damage NTSB ANC73DAG97Accident · Minor injuriesClosedAeronca 7AC · Spenard, AKJun 29, 1973 · N1359E · Substantial damage NTSB CHI73FEG29Accident · Minor injuriesClosedLuscombe 8F · New Lebanon, OHJun 17, 1973 · N1382B · Substantial damage NTSB LAX73DUQ40Accident · No injuriesClosedChampion 7FC · Mojave, CAJun 16, 1973 · N9883Y · Substantial damage