Final NTSB investigations: Continental 0-300-D
12 cases on aircraft whose registry engine model is Continental 0-300-D. 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 | 1 |
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 1 |
| 1970 | 1 |
| 1972 | 1 |
| 1976 | 1 |
| 1985 | 1 |
| 1989 | 1 |
| 2014 | 1 |
| 2023 | 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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17176'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17176'))
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 CEN23LA367Accident · No injuriesClass 3 · LimitedFinal reportCessna 172B · San Angelo, TXA partial loss of engine power due to loose bolts holding the carburetor throttle body to the fuel bowl.NTSB WPR14CA224Accident · No injuriesData collectionFinal reportMeyers MAC 145 · La Cholla, AZThe pilot's overcorrection to a wind gust, which resulted in a loss of directional control and runway veeroff.NTSB ATL89LA102Accident · No injuriesLimited investigationFinal reportCessna 172G · Coolidge, GAFuel contamination of an unknown origin, failure of company maintenance personnel to locate and remove all contamination, continued operation of the aircraft by the pilot after the cause of a known engine problem was not determined, and subsequent fuel…NTSB LAX85LA114Accident · No injuriesLimited investigationFinal reportCessna 172E · San Carlos, AZThe student plt over rotated the acft while practicing a soft field takeoff. In an attempt to gain airspeed the acft stalled and impacted the rwy.NTSB OAK76DVA74Accident · No injuriesClosedCessna 172 · Orange Cove, CANTSB FTW72DRD20Accident · Minor injuriesClosedCessna 172D · Lorcauville, LANTSB OAK71FVM07Accident · Minor injuriesClosedCessna 172 · Palo Alto, CANTSB DIA69F0036Accident · No injuriesClosedCessna 172 · Richmond, VANTSB MKC67D0570Accident · No injuriesClosedCessna 172 · Grimes, IANTSB NYC66F0695Accident · No injuriesClosedGlobe GC1B · Philippi, WVNTSB MKC66A0026Accident · 3 fatalClosedCessna 172E · Kansas City, MONTSB UNK65X0874Accident · Minor injuriesClosedCessna 172 · Madison, CT