NTSB investigations: Continental C90 series, MD
14 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 | 1 |
|---|---|
| 1965 | 4 |
| 1966 | 2 |
| 1968 | 1 |
| 1969 | 1 |
| 1971 | 1 |
| 1976 | 1 |
| 1984 | 1 |
| 1986 | 1 |
| 2012 | 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\" = 'MD' 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" = 'MD' 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 ERA12CA413Accident · Minor injuriesData collectionFinal reportMooney M10 · Hurlock, MDThe pilot's failure to see and avoid power lines during final approach to landing.NTSB BFO86FIG03Accident · No injuriesFinal reportChampion 7FC · Baltimore, MDThe acft was observed to touch down hard on the sod rwy, bounce into the air, and come back down on the left main and nose wheel. The nose wheel fork broke and the nose wheel departed the acft. The acft continued to slide for aprx 24 ft after which time it…NTSB BFO85LA010Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Newburg, MDDuring ldg roll the PIC felt a vibration as the tailwheel contacted the rwy. In an effort to minimize the vibration the plt lifted the tailwheel off the rwy. The acft began to ground loop to the right toward a pole. Heavy application of the wheel brakes…NTSB IAD76DIG17Accident · No injuriesClosedAeronca 7CCM · Cumberland, MDNTSB IAD71DIG25Accident · No injuriesClosedPiper J-3 · College Park, MDNTSB IAD70D0087Accident · No injuriesClosedAeronca S-7CCM · Annapolis, MDNTSB DIA69F0112Accident · No injuriesClosedAeronca 7EC · Gaithersburg, MDNTSB NYC67F0352Accident · No injuriesClosedAlon A-2 · Deale, MDNTSB NYC67D0049Accident · No injuriesClosedLuscombe 8F · Newburg, MDNTSB NYC66F0306Accident · No injuriesClosedCessna 140 · Gaithersburg, MDNTSB NYC66D0159Accident · Minor injuriesClosedChampion 7FC · Easton, MDNTSB NYC66F0064Accident · Serious injuriesClosedPiper J3C · Baltimore, MDNTSB NYC66D0111Accident · No injuriesClosedChampion 7FC · Laytonsville, MDNTSB UNK64X0563Accident · No injuriesClosedChampion 7FC · Westminister, MD