NTSB investigations: Continental TSIO-360 series, LA
8 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
| 1978 | 1 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 2011 | 2 |
| 2018 | 1 |
| 2022 | 1 |
| 2024 | 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\" = 'LA' 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" = 'LA' 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 CEN25LA021Accident · No injuriesClass 3 · LimitedFinal reportMooney M20K · Elizabeth, LAThe pilot’s failure to set the engine fuel mixture to the required setting, which resulted in reduced engine power during a go-around and subsequent impact with trees. Contributing to the accident, the failure of the mechanic to perform a current fuel…NTSB CEN22LA162Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-220T · Slidell, LAThe flight instructor’s failure to adequately correct for a loss of directional control during a simulated single engine approach.NTSB CEN18LA093Accident · Serious injuriesLimited investigationFinal reportPiper PA 34-220T · Patterson, LAThe pilot's inadequate in-flight fuel management, which resulted in a dual loss of engine power due to fuel exhaustion.NTSB CEN11LA529Accident · Minor injuriesLimited investigationFinal reportMooney M20K · Opelousas, LAThe loss of engine power due to fuel contamination.NTSB CEN11LA311Accident · No injuriesLimited investigationFinal reportMooney M20K · New Orleans, LAA loss of electrical and engine power for undetermined reasons.NTSB FTW85FA247Accident · 2 fatalField investigationFinal reportPiper PA-28RT-201T · Pineville, LAThe aircraft landed long and fast on the relatively short, sloping runway. After bouncing four times, the pilot rapidly added throttle on the turbocharger-equipped aircraft and attempted to climb. Witnesses observed smoke from the exhaust, and described high…NTSB FTW84LA341Accident · No injuriesLimited investigationFinal reportMooney M20 · Thibodaux, LAAt 0729 CDT the plt filed a flight plan and obtained a wx brief forecasting moist unstable air with several scattered and broken cloud layers beginning at 1,500 ft. the briefer further advised the plt of thunderstorm activity at various locations along the…NTSB FTW79DRD02Accident · No injuriesClosedPiper PA-34 · Westwego, LA