NTSB investigations: Continental 0-300 series, 2001
5 cases on aircraft whose registry engine model is Continental 0-300 series, where the first occurrence was “Loss of control - in flight”. 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 | 1 |
|---|---|
| 1983 | 5 |
| 1984 | 4 |
| 1985 | 3 |
| 1986 | 3 |
| 1987 | 5 |
| 1988 | 3 |
| 1989 | 3 |
| 1991 | 3 |
| 1992 | 5 |
| 1993 | 5 |
| 1994 | 5 |
| 1995 | 2 |
| 1996 | 3 |
| 1997 | 2 |
| 1998 | 7 |
| 1999 | 2 |
| 2000 | 4 |
| 2001 | 5 |
| 2002 | 4 |
| 2003 | 5 |
| 2004 | 4 |
| 2005 | 5 |
| 2006 | 4 |
| 2007 | 3 |
Where
Latest 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\") = 2001
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\" = 250))
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") = 2001
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" = 250))
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 NYC02FA012Accident · 3 fatalField investigationFinal reportCessna 172 · South Hero, VTThe pilot's failure to maintain aircraft control during the takeoff. Factors in this accident were wind gusts and the airplane's high gross weight condition.NTSB NYC01LA227Accident · No injuriesLimited investigationFinal reportCessna 170B · Wildwood, NJthe pilot's inadequate compensation for wind conditions. Factors were the crosswind and the gusts.NTSB NYC01FA147Accident · 1 fatalField investigationFinal reportCessna 172 · Newfane, VTThe pilot's failure to maintain aircraft control during takeoff. A factor was the pilot's impairment due to a narcotic painkiller and antihistamine.NTSB FTW01LA106Accident · No injuriesLimited investigationFinal reportCessna 172G · N. Little Rock, ARthe pilot's delayed go-around on landing.NTSB LAX01FA070Accident · 2 fatalField investigationFinal reportCessna 172F · San Luis Obispo, CAThe pilot's failure to maintain a proper climb rate to VFR conditions on-top.