NTSB investigations: Continental TSIO-360 series, AZ
14 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 |
|---|---|
| 1979 | 1 |
| 1980 | 2 |
| 1985 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 2003 | 1 |
| 2005 | 1 |
| 2010 | 1 |
| 2016 | 1 |
| 2017 | 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\" = 'AZ' 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" = 'AZ' 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 WPR23LA332Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-34-200T · Coolidge, AZThe pilot's failure to extend the landing gear before landing.NTSB WPR18LA044Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 34-200T · Glendale, AZThe pilot's failure to maintain directional control of the airplane during the landing roll. Contributing to the accident was the fatigue of the left main landing gear assembly.NTSB WPR16FA158Accident · 1 fatalField investigationFinal reportPiper PA 34-200T · Flagstaff, AZA departure flight path that consisted of several unexplained turns during the initial climbout, and terminated in a high-speed descent and ground impact. The reason(s) for the turns and descent could not be determined due to lack of definitive evidence.NTSB WPR10LA240Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Sedona, AZThe pilot's improper landing flare in tailwind conditions, which resulted in a hard landing.NTSB LAX05CA177Accident · No injuriesData collectionFinal reportPiper PA-34-220T · Scottsdale, AZthe student pilot's inadvertent retraction of the landing gear, and the flight instructor's inadequate supervision of the flight.NTSB LAX03LA302Accident · No injuriesLimited investigationFinal reportPiper PA-34-220T · Show Low, AZThe pilot-in-command's (CFI) selection of the wrong runway (downwind) for the approach and landing. The failure of the left engine to respond to throttle application for undetermined reasons during the go-around was also causal. The high density altitude was…NTSB LAX91LA063Accident · No injuriesLimited investigationFinal reportCessna 172 · Tucson, AZBoth pilots used poor visual lookout procedures.NTSB LAX88LA213Accident · Minor injuriesLimited investigationFinal reportPiper PA-28RT-201T · Grand Canyon, AZFailure of the an tee fitting, thereby allowing the oil to be pumped overboard causing the engine failure. The failure of the tee fitting was caused by the tie wrap used to secure the line. The tie wrap pulled the oil line and stressed one side of the tee…NTSB LAX87FA066Accident · 1 fatalField investigationFinal reportMooney M20K · Flagstaff, AZThe pilot encountered clouds and temperatures below freezing during a cross country flight at 17,500 feet above mean sea level. The engine failed shortly after the encounter with the weather. The pilot was unable to restart the engine during the forced…NTSB LAX86LA067Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200T · Glendale, AZAfter completing a LCL flight the plt returned to his home base arpt & proceeded to land on the 2400 ft long rwy. The plt reported that he was unable to stop at its end and collided with barricades and a fence. A witness reported that the acft skidded on the…NTSB LAX81DUJ24Accident · No injuriesClosedPiper PA-34 · Whiteriver, AZNTSB LAX81DUJ74Accident · No injuriesClosedPiper PA-34 · Flagstaff, AZNTSB LAX79DUK05Accident · No injuriesClosedMooney M20K · Flagstaff, AZNTSB LAX78DUJ80Accident · No injuriesClosedPiper PA-28R · Dolan Springs, AZ