NTSB investigations: Continental 0-300 series, 1983, IN
3 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 | 6 |
|---|---|
| 1965 | 7 |
| 1966 | 4 |
| 1967 | 3 |
| 1968 | 4 |
| 1970 | 2 |
| 1971 | 2 |
| 1973 | 1 |
| 1974 | 1 |
| 1976 | 2 |
| 1977 | 2 |
| 1978 | 1 |
| 1980 | 1 |
| 1981 | 3 |
| 1982 | 1 |
| 1983 | 3 |
| 1984 | 1 |
| 1986 | 1 |
| 1987 | 2 |
| 1988 | 2 |
| 1989 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2003 | 1 |
| 2006 | 2 |
| 2018 | 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\") = 1983
AND c.\"eventStateOrRegion\" = 'IN' 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") = 1983
AND c."eventStateOrRegion" = 'IN' 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 CHI84LA044Accident · No injuriesLimited investigationFinal reportCessna 172 · Kentland, INThe acft ran off the rwy into soft dirt during landing roll and cartwheeled. The student plt landed on rwy 27 with windsreported from the south at 18-20 KTS. After a 100 ft ground roll the acft left the rwy to the right into an open field where it cartwheeled.NTSB CHI83LA417Accident · No injuriesLimited investigationFinal reportCessna 172H · Wolcott, INThe student pilot was practicing touch-and-go landings. He stated he landed long with the right wing scraping a shed. The acft continued off the end of the rwy and struck a tree before coming to a stop.NTSB CHI83LA363Accident · No injuriesLimited investigationFinal reportCessna 172 · Grandview, INThe acft collided with an unseen rut in an off arpt landing on an unprepared grass field. The nose gear collapsed and the acft nosed over. The weather was VMC and no flt plan was filed. The pilot made a low pass over this field and saw no obstacles so he…