NTSB investigations: Continental IO-360 series, AZ
20 cases on aircraft whose registry engine model is Continental IO-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
| 1968 | 1 |
|---|---|
| 1969 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1983 | 1 |
| 1984 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1997 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2006 | 1 |
| 2009 | 1 |
| 2011 | 1 |
| 2012 | 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 ('17025', '17045'))
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 ('17025', '17045'))
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 WPR13LA011Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Parker, AZThe pilot's failure to perform an adequate preflight inspection, which resulted in inadequate fuel for the flight and the subsequent fuel exhaustion and a total loss of engine power. Contributing to the accident was the pilot's failure to land the airplane at…NTSB WPR11FA354Accident · 2 fatalField investigationFinal reportCirrus SR20 · Fredonia, AZThe non-instrument-rated pilots’ loss of situational awareness during a dark night flight over a remote area, which resulted in their failure to maintain an altitude sufficient to ensure adequate terrain clearnance. Contributing to the accident was the…NTSB WPR09LA480Accident · No injuriesLimited investigationFinal reportCessna R172K · Page, AZThe pilot's improper landing flare and inadequate recovery from a bounced landing.NTSB LAX06FA283Accident · 3 fatalField investigationFinal reportCessna 337G · Prescott, AZA loss of power in the rear engine for undermined reasons. Contributing to the accident was the pilot's failure to promptly and correctly configure the airplane for single engine flight, and to maintain an adequate airspeed, which resulted in a stall mush.NTSB LAX05FA035Accident · 3 fatalField investigationFinal reportCessna 337B · Drake, AZthe pilot's failure to maintain airspeed above stall speed while maneuvering at low altitude, which resulted in an accelerated stall and spin. A factor in the accident was the pilot's performance of maneuvering flight at an altitude insufficient to allow for…NTSB LAX03CA219Accident · No injuriesData collectionFinal reportStinson 108-3 · St. Johns, AZthe pilot's inadequate compensation for the gusting and shifting wind conditions, which resulted in a failure to maintain directional control and a ground loop. The gusting and shifting wind conditions were factors in the accident.NTSB LAX97FA093Accident · 1 fatalField investigationFinal reportCessna R172K · Bagdad, AZcontinued flight by the pilot into adverse weather conditions, and his failure to maintain sufficient altitude or clearance from terrain. Factors relating to the accident were: the high/mountainous terrain and adverse weather conditions.NTSB LAX94LA001Accident · No injuriesLimited investigationFinal reportCessna O-2A · Tucson, AZwas the partial loss of engine power during initial climb due to partial clogging of the engine's fuel injectors. Blockage of the fuel injectors was due to inadequate maintenance of the fuel system by contract maintenance personnel.NTSB LAX93LA008Accident · No injuriesLimited investigationFinal reportCessna R172K · Picacho, AZThe pilot's encounter with the unforecasted cyclonic wind.NTSB LAX91FA209Accident · 1 fatalField investigationFinal reportUniversal Globe GC-1B · Chandler, AZThe pilot-in-command's failure to maintain airspeed in a forced landing resulting in an in flight loss of control, stall, and subsequent in flight colliison with terrain. Factor related to the accident was the pilot's improper procedure which restuled in a…NTSB LAX84FUJ03Accident · Serious injuriesFinal reportCessna T337E · Chandler, AZThe plt reported that on the first attempt to rotate, the stall warning horn activated. The plt noticed the rear eng in an overboost cond so he retarded the throttle completely, then advanced it to below red line. He continued the takeoff and attempted to…NTSB LAX83LA293Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Wickenburg, AZThe acft left the runway during landing and collided with a ditch which collapsed the right main gear and nose gear. Thepilot noted during final approach that the windsock did not indicate a cross-wind. The landing was made with 10 degrees of flaps. According…NTSB LAX81FA033Accident · 1 fatalClosedMaule M-4 · Globe, AZNTSB LAX80DUJ34Accident · Minor injuriesClosedCessna R172K · Concho, AZNTSB LAX79FUJ05Accident · Minor injuriesClosedCessna T337B · Marana, AZNTSB LAX77DUJ35Accident · No injuriesClosedMaule M-4210 · Prescott, AZNTSB LAX72FUJ67Accident · No injuriesClosedCessna 337C · Tucson, AZNTSB LAX71DUJ10Accident · No injuriesClosedCessna 337 · Tucson, AZNTSB LAX70D0112Accident · No injuriesClosedCessna T337C · Wickenburg, AZNTSB LAX69D0025Accident · No injuriesClosedCessna 337 · Tombstone, AZ