NTSB investigations: Continental TSIO-360 series, NC
7 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
| 1977 | 1 |
|---|---|
| 1978 | 1 |
| 1979 | 1 |
| 1984 | 1 |
| 1991 | 1 |
| 2002 | 1 |
| 2013 | 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\" = 'NC' 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" = 'NC' 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 ERA13LA113Accident · 1 fatalLimited investigationFinal reportPiper PA-34-200T · Manteo, NCThe pilot's attempted visual flight in instrument meteorological conditions while maneuvering at a low altitude in the traffic pattern, which resulted in spatial disorientation and impact with the water. Contributing was the pilot's lack of experience flying…NTSB ATL02FA069Accident · 2 fatalField investigationFinal reportPiper PA-34-200T · Apex, NCThe pilot experienced spatial disorientation that resulted in the loss of control and the overload failure of the airframe. A factor was low visibility and ceilings.NTSB ATL92FA008Accident · 1 fatalField investigationFinal reportPiper PA-28RT-201T · Spring Lake, NCThe inadvertent flight from visual flight rules flight conditions into instrument flight rules flight conditions by the non-instrument rated pilot, and his subsequent failure to maintain control of the aircraft.NTSB ATL84FA126Accident · 1 fatalField investigationFinal reportPiper PA-34-200T · Fletcher, NCDuring takeoff the left eng lost power shortly after the landing gear was retracted. The plt stated that he felt the loss of power at about the same time that he turned off the landing lights. With the left eng manifold pressure gauge reading 25 inches hg,…NTSB IAD80AA008Accident · 3 fatalClosedCessna P337H · Benson, NCNTSB IAD78DLJ25Accident · No injuriesClosedCessna 188B · Zebvlon, NCNTSB IAD77DA033Accident · No injuriesClosedPiper PA-34 · Charlotte, NC