NTSB investigations: Continental 0-300 series, CT
20 cases on aircraft whose registry engine model is Continental 0-300 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 | 3 |
| 1966 | 3 |
| 1967 | 3 |
| 1969 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 2 |
| 1979 | 2 |
| 1996 | 1 |
| 2003 | 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\" = 'CT' 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 ('17022'))
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" = 'CT' 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 ('17022'))
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 NYC03LA084Accident · No injuriesLimited investigationFinal reportMaule M4 · Danielson, CTThe pilot's inadequate compensation for winds, and failure to maintain directional control. A factor in this accident was the crosswind condition.NTSB IAD96FA057Accident · 3 fatalField investigationFinal reportCessna 172 · Barkhamsted, CTthe CFI pilot/passenger's poor judgment which led to spatial disorientation and subsequent loss of control of the airplane. Factors involved in this accident were the night marginal visual flight conditions and continuing flight with a known nonfunctioning…NTSB NYC80FNE07Accident · No injuriesClosedCessna 172 · Burlington, CTNTSB NYC79FA104Accident · 1 fatalClosedCessna 172D · Greenwich, CTNTSB NYC72DNE32Accident · No injuriesClosedGlobe GC-1B · Plainville, CTNTSB NYC72FNE31Accident · No injuriesClosedCessna 172C · Simsbury, CTNTSB NYC72FNE19Accident · Minor injuriesClosedCessna 172F · Kent, CTNTSB NYC70DFM14Accident · No injuriesClosedCessna 172 · Stratford, CTNTSB NYC69A0071Accident · No injuriesClosedCessna 172 · Plainville, CTNTSB NYC68D0310Accident · No injuriesClosedCessna 172 · Groton, CTNTSB NYC68D0149Accident · Serious injuriesClosedCessna 172E · Ea.Hampton, CTNTSB NYC67D0472Accident · Minor injuriesClosedCessna 172 · Trumbull, CTNTSB NYC67D0105Accident · No injuriesClosedCessna 172 · Madison, CTNTSB NYC67D0052Accident · Minor injuriesClosedCessna 172 · Waterbury, CTNTSB NYC67D0020Accident · No injuriesClosedCessna 172 · Ansonia, CTNTSB NYC66F0244Accident · No injuriesClosedCessna 172 · Harwinton, CTNTSB NYC66F0069Accident · No injuriesClosedCessna 172F · E Killingly, CTNTSB NYC65F0067Accident · No injuriesClosedCessna 172 · Bolton, CTNTSB UNK64X3839Accident · No injuriesClosedCessna 172 · Madison, CTNTSB UNK64X1352Accident · No injuriesClosedCessna 172 · Woodstock, CT