NTSB investigations: Continental C90 series, ND
21 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.
Cases per year
| 1964 | 2 |
|---|---|
| 1965 | 2 |
| 1966 | 2 |
| 1967 | 1 |
| 1968 | 4 |
| 1969 | 2 |
| 1970 | 3 |
| 1971 | 1 |
| 1974 | 2 |
| 1982 | 1 |
| 2000 | 1 |
Where
Open the mapLatest cases
Query with SQL
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.\"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" = 'ND' 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" DESCRun 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 CHI00LA109Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Sherwood, NDcarburetor ice and the pilot's improper decisions when to use carburetor heat and to perform a soft field landing. Factors relating to this accident were the improper use of carburetor heat, the soft field landing attempt, and the snow covered field.NTSB DEN82DA050Accident · Serious injuriesFinal reportPiper PA-11 · Devils Lake, NDThe pilot and passenger/pilot were making low, slow passes over fisherman on the ice. The pilot reversed directions and the aircraft stalled. The pilot stated he was looking at the ground and became distracted.NTSB MKC75D1G16Accident · No injuriesClosedPiper J3C-65 · Esmond, NDNTSB MKC75DTG03Accident · No injuriesClosedPiper PA-11 · Maddock, NDNTSB MKC71FTG30Accident · Minor injuriesClosedPiper PA-11 · Petersburg, NDNTSB MKC71DDD05Accident · No injuriesClosedPiper PA-11 · Michigan, NDNTSB MKC70DDD05Accident · No injuriesClosedPiper PA-18 · Noonan, NDNTSB MKC70DDD02Accident · No injuriesClosedAeronca 7EC · Benedict, NDNTSB MKC70F0037Accident · No injuriesClosedLuscombe T-8F · Hillsboro, NDNTSB MKC69D0467Accident · No injuriesClosedChampion 7EC · Plaza, NDNTSB MKC69F0297Accident · No injuriesClosedPiper PA-11 · Harvey, NDNTSB MKC69D0144Accident · No injuriesClosedAlon A-2 · Steele, NDNTSB MKC69F0049Accident · No injuriesClosedCessna 140A · Mandan, NDNTSB MKC68D0600Accident · No injuriesClosedAeronca 7EC · Benedict, NDNTSB MKC67D0512Accident · No injuriesClosedAeronca 7AC · Bowman, NDNTSB MKC67F0046Accident · No injuriesClosedPiper J3C-65 · Regent, NDNTSB MKC66D0417Accident · No injuriesClosedPiper PA-11 · Rugby, NDNTSB MKC66F0041Accident · Serious injuriesClosedPiper PA-11 · Churchsferry, NDNTSB MKC66F0179Accident · No injuriesClosedCessna 140A · Almo, NDNTSB UNK64X2149Accident · No injuriesClosedPiper PA11 · Churchs Ferry, NDNTSB UNK64X2096Accident · No injuriesClosedChampion 7FC · West Fargo, ND