NTSB investigations: Continental 0-300 series, 1986, TX
4 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 | 15 |
|---|---|
| 1965 | 16 |
| 1966 | 12 |
| 1967 | 16 |
| 1968 | 9 |
| 1969 | 6 |
| 1970 | 9 |
| 1971 | 10 |
| 1972 | 6 |
| 1973 | 6 |
| 1974 | 2 |
| 1975 | 7 |
| 1976 | 3 |
| 1977 | 3 |
| 1978 | 6 |
| 1979 | 3 |
| 1981 | 2 |
| 1982 | 3 |
| 1983 | 5 |
| 1984 | 2 |
| 1986 | 4 |
| 1987 | 3 |
| 1988 | 2 |
| 1990 | 1 |
| 1992 | 4 |
| 1993 | 3 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1998 | 3 |
| 1999 | 2 |
| 2000 | 3 |
| 2001 | 1 |
| 2002 | 2 |
| 2003 | 2 |
| 2004 | 1 |
| 2005 | 2 |
| 2007 | 3 |
| 2008 | 3 |
| 2009 | 2 |
| 2010 | 1 |
| 2011 | 2 |
| 2013 | 1 |
| 2014 | 1 |
| 2015 | 2 |
| 2018 | 4 |
| 2019 | 4 |
| 2020 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 5 |
| 2025 | 4 |
| 2026 | 2 |
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\") = 1986
AND c.\"eventStateOrRegion\" = 'TX' 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 year(c."eventDate") = 1986
AND c."eventStateOrRegion" = 'TX' 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 FTW87FA022Accident · Minor injuriesField investigationFinal reportCessna 172C · Amarillo, TXThe certificated stu plt of the citabria was making touch and go landings at the uncontrolled arpt when the accident occurred. He took off to the south flying a left hand traffic pattern. The base to final turn was made aprx 1/4 mile from the rwy in front of…NTSB FTW86LA155Accident · No injuriesLimited investigationFinal reportCessna 172A · Gainesville, TXThe pilot was taxiing into position for takeoff, when there was a wind shift and a gust of wind inverted the aircraft. The pilot had not obtained any weather reports prior to taxiing out to the runway. There were thunderstorms in the area and a heavy rain…NTSB FTW86LA038Accident · No injuriesLimited investigationFinal reportCessna 172G · Spring, TXThe pilot continued VFR flight into IFR weather conditions which he had encountered near his destination during the last few moments of his approximate four hour, night, cross-country flight. He then turned back to houston intercontinental airport to land. He…NTSB FTW86LRA03Accident · No injuriesFinal reportCessna 172F · Saratoga, TXPilot was enroute from rocksprings, TX. To hardin county airport near kountz, TX. As pilot appoached Saratoga, TX., the engine quit due to fuel exhaustion. Pilot landed in field near Saratoga causing substantial damage to the aircraft. No injuries were…