NTSB investigations: Continental TSIO-360 series, OH
9 cases on aircraft whose registry engine model is Continental TSIO-360 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
| 1979 | 1 |
|---|---|
| 1987 | 1 |
| 1992 | 1 |
| 2001 | 1 |
| 2004 | 1 |
| 2008 | 2 |
| 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.\"eventStateOrRegion\" = 'OH' 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 ('17019', '17023'))
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."eventStateOrRegion" = 'OH' 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 ('17019', '17023'))
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 ERA23LA344Accident · No injuriesClass 3 · LimitedFinal reportMooney M20K · Fostoria, OHA loss of engine power for unknown reasons.NTSB CEN14LA489Accident · No injuriesLimited investigationFinal reportGallager John C Glasair · Highland Heights, OHThe pilot’s loss of aircraft control during landing, and his failure to maintain directional control.NTSB CHI08CA163Accident · No injuriesData collectionFinal reportMooney M20K · New Philadelphi, OHThe pilot's failure to extend the landing gear prior to landing.NTSB CHI08CA140Accident · No injuriesData collectionFinal reportPiper PA-34-200T · Sandusky, OHThe pilot misjudging the flare and not maintaining airspeed during the landing.NTSB NYC04CA110Accident · No injuriesData collectionFinal reportPiper PA-34-220T · Willoughby, OHThe pilot's improper flare, which resulted in a hard landing. A factor in this accident was the gusty wind conditions associated with thunderstorm activity.NTSB IAD01LA043Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Painesville, OHThe pilot's failure to maintain the proper descent rate and the flight instructor's inadequate supervision.NTSB BFO92LA024Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Columbus, OHFuel starvation in both engines, due to the pilot's improper positioning of the engine or fuel controls.NTSB ATL87FA142Accident · 4 fatalField investigationFinal reportCessna T337G · Oxford, OHThe pilot was advised against attempting a visual flight with rain and thunderstorm activity along the intended route of flight. Approach control instructed him to maintain visual conditions and not to enter the clouds. The pilot lost control of the aircraft…NTSB CHI80FEI09Accident · No injuriesClosedPiper PA-34 · Youngstown, OH