NTSB investigations: Continental 0-300 series, 2003
6 cases on aircraft whose registry engine model is Continental 0-300 series, where the first occurrence was “Loss of control - on ground/water”. 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
| 1982 | 4 |
|---|---|
| 1983 | 10 |
| 1984 | 4 |
| 1985 | 4 |
| 1986 | 9 |
| 1987 | 4 |
| 1988 | 7 |
| 1989 | 2 |
| 1990 | 5 |
| 1991 | 3 |
| 1992 | 5 |
| 1993 | 7 |
| 1994 | 4 |
| 1995 | 1 |
| 1996 | 3 |
| 1997 | 2 |
| 1998 | 3 |
| 1999 | 5 |
| 2000 | 2 |
| 2001 | 4 |
| 2002 | 6 |
| 2003 | 6 |
| 2004 | 5 |
| 2005 | 2 |
| 2006 | 7 |
| 2007 | 2 |
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 year(c.\"eventDate\") = 2003
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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 year(c."eventDate") = 2003
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 ATL04CA041Accident · No injuriesData collectionFinal reportGlobe Swift GC1B · Southern Pines, NCThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent ground loop and the collapse of the landing gear.NTSB CHI04LA012Accident · Minor injuriesLimited investigationFinal reportCessna 172F · Columbus, NEThe student pilot's inadequate compensation for wind conditions and his failure to maintain directional control of the airplane during an aborted takeoff. Factors associated with the accident were the crosswind condition, the delayed aborted takeoff, and the…NTSB ANC03CA097Accident · No injuriesData collectionFinal reportCessna 170B · Sparrevohn, AKThe pilot's inadequate compensation for a crosswind, which resulted in collapse of the left main landing gear during the takeoff roll. A factor was the crosswind.NTSB MIA03CA165Accident · No injuriesData collectionFinal reportCessna 170B · La Belle, FLThe failure of the pilot to maintain directional control during takeoff resulting in ground looping and substantial damage.NTSB FTW03LA138Accident · Minor injuriesLimited investigationFinal reportCessna 172C · Pecos, TXThe failure of the pilot to maintain aircraft control while landing. A contributing factor was the gusty wind condition.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.