NTSB investigations: Continental C90 series, AZ
19 cases on aircraft whose registry engine model is Continental C90 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
| 1964 | 1 |
|---|---|
| 1967 | 1 |
| 1969 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1977 | 1 |
| 1981 | 1 |
| 1982 | 2 |
| 1986 | 1 |
| 1988 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 1998 | 1 |
| 2001 | 1 |
| 2021 | 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 ('17009'))
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 ('17009'))
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 WPR21LA166Accident · 2 fatalClass 3 · LimitedFinal reportCessna 140 · Williams, AZThe pilot’s loss of control due to spatial disorientation shortly after takeoff in night visual meteorological conditions.NTSB LAX01LA090Accident · Minor injuriesLimited investigationFinal reportLuscombe 8F · Tombstone, AZThe pilot's lack of directional control on the landing roll, which resulted in a ground loop and inadvertent nose over.NTSB LAX98LA071Accident · No injuriesLimited investigationFinal reportCessna 140 · Goodyear, AZThe inadvertent brake activation by the student pilot while practicing touch-and-go landings.NTSB LAX98FA064Accident · 1 fatalField investigationFinal reportPiper PA-11 · Willow Beach, AZThe pilot's failure to maintain control of the aircraft for undetermined reasons.NTSB LAX95LA102Accident · Minor injuriesLimited investigationFinal reportLuscombe 8F · Wickenburg, AZThe pilot-rated passenger's failure to maintain directional control of the airplane during the takeoff ground roll, and the pilot-in-command's inadequate supervision of the pilot-rated passenger, who had sole access to the airplane's brakes.NTSB LAX93LA251Accident · No injuriesLimited investigationFinal reportAlon A2 · Goodyear, AZthe pilot's failure to maintain adequate obstruction clearance while taxiing. A factor in the accident was the pilot's attention being diverted by the movement of two trucks.NTSB LAX91LA397Accident · No injuriesLimited investigationFinal reportAeronca 7FC · Phoenix, AZThe pilot's improper remedial action. Contributing to this accident was the pilot's improper use of the brakes and rudder and his lack of experience in the accident airplane's make and model.NTSB LAX88LA166Accident · No injuriesLimited investigationFinal reportChampion 7EC · Mayer, AZNTSB LAX86LA322Accident · 2 fatalLimited investigationFinal reportLuscombe 8F · Marble Canyon, AZWitnesses rprtd that prior to the acdnt, the plt made a low pass over a raft on the Colorado river to 'wave his wings' at the rafting group. Rprtdly, he was attempting to reverse his direction when the acft suddenly crashed in the river. A search was…NTSB LAX83LA006Accident · Minor injuriesLimited investigationFinal reportCessna 140A · Wickenburg, AZThe pilot stated the aircraft touched the runway then ballooned during a wheels-first landing. After the pilot decided to execute a go-around and the aircraft became airborne, it became apparent that the aircraft could not clear rising terrain. The pilot cut…NTSB LAX82DA173Accident · No injuriesFinal reportAeronca 7EC · Prescott, AZFollowing a wheel landing the aircraft bounced and made a three point landing. After crossing a runway intersection the aircraft developed a left turning tendency which the pilots stated they could not control. The aircraft ran into a ditch.NTSB LAX81FUJ75Accident · No injuriesClosedCessna 140 · Glendale, AZNTSB LAX77FUJ22Accident · Minor injuriesClosedForney F-1 · Phoenix, AZNTSB LAX75DUJ55Accident · No injuriesClosedForney F-1A · Mcneal, AZNTSB LAX73FUJ87Accident · No injuriesClosedAlon A-2 · Glendale, AZNTSB LAX73DUJ76Accident · No injuriesClosedErco 415D · Lk Hvsu Cty, AZNTSB LAX70F0072Accident · No injuriesClosedCessna 140A · Tucson, AZNTSB LAX67A0099Accident · 2 fatalClosedHelton Lark 95 · Willcox, AZNTSB UNK64X0713Accident · No injuriesClosedChampion 7FC · Harquahala, AZ