NTSB investigations: Continental C90 series
11 cases on aircraft whose registry engine model is Continental C90 series, where the first occurrence was “In flight collision with object”. 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1987 | 2 |
| 1989 | 1 |
| 1990 | 2 |
| 1991 | 1 |
| 2001 | 1 |
| 2006 | 2 |
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17009')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17009')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
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 NYC07CA028Accident · Minor injuriesData collectionFinal reportPiper PA-11 · Van Hornsville, NYThe pilot's failure to maintain clearance from trees during landing.NTSB NYC06CA194Accident · Serious injuriesData collectionFinal reportChampion 7FC · Harmonsburg, PAThe pilot's failure to maintain the proper altitude/clearance on final approach, which resulted in an in-flight collision with trees.NTSB DEN02LA008Accident · Minor injuriesLimited investigationFinal reportCessna 140 · Nephi, UTThe pilot's failure to maintain clearance with the transmission wires while maneuvering. A contributing factor was the low altitude flight performed by the pilot.NTSB FTW91LA099Accident · No injuriesLimited investigationFinal reportChampion 7FC · Medina, TXThe pilot's inadequate visual lookout.NTSB ATL90LA131Accident · No injuriesLimited investigationFinal reportChampion Aeronca 7CCM · Albany, GAFailure of the pilot in command to directional control on takeoff initial climb, and failure to maintain a visual lookout for obstacles.NTSB SEA90LA090Accident · Minor injuriesLimited investigationFinal reportPiper PA18 · Palouse, WAThe pilots poorly planned approach for landing.NTSB ANC89LA047Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Igiugig, AKThe pilot's failure to maintain control of the airplane and his failure to understand the performance parameters of his airplane.NTSB CHI87LA080Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Big Fork, MNAfter several unsuccessful attempts to takeoff from a snow-covered lake, the plt found a plowed area leading to a fish house. He taxied to the area and began to takeoff towards the east. On lift-off, the left aileron struck the top of the fish house. The plt…NTSB ANC87FA033Accident · No injuriesField investigationFinal reportChampion 7EC · Kenai, AKThe pilot allowed the wing tip to descend into brush and willows while turning to avoid obscured sky conditions. The turn was downwind and the airplane stalled and struck the snow while skidding sideways.NTSB ANC83LA128Accident · Minor injuriesLimited investigationFinal reportPiper PA-11 · Kasilof, AKThe acft collided with trees and crashed during takeoff. The plt stated he made several attempts to get airborne in bothdirections from the strip and when he finally got airborne he struck a tree and crashed. The plt statements varied during several…NTSB FTW82DPM10Accident · Serious injuriesFinal reportCessna 140A · Wagoner, OKDuring a low pass over a river, the aircraft struck some power lines approximately 125 ft above the water level.