Skip to content

NTSB investigations: Continental C90 series, VA

20 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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" = 'VA' 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

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\" = 'VA' 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" = 'VA' 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

Run 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 ERA21LA358Accident · Minor injuriesClass 4 · LimitedFinal reportAlon A2 · Abingdon, VAThe failure of a nosewheel steering actuator arm, which resulted in a loss of control during the landing rollout.Sep 13, 2021 · N5644F · Substantial damage NTSB ERA21LA022Accident · No injuriesClass 4 · LimitedFinal reportChampion 7FC · Moneta, VAThe fight instructor’s failure to ensure that the fuel selector handle was in the correct position, which resulted in a total loss of engine power during initial climb due to fuel starvation.Oct 14, 2020 · N7532E · Substantial damage NTSB GAA18CA448Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Lawrenceville, VAThe pilot’s failure to maintain directional control during the landing roll with a tailwind.Jul 26, 2018 · N1489B · Substantial damage NTSB ERA09LA506Accident · No injuriesLimited investigationFinal reportCessna 140 · Louisa, VAThe Cessna pilot's inadequate visual lookout.Sep 5, 2009 · N3656V · 2 aircraft · Minor damage NTSB NYC99LA117Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Leesburg, VAThe pilot-in-command's (CFI) failure to maintain control of the airplane.May 21, 1999 · N78659 · Substantial damage NTSB NYC95LA115Accident · 1 fatalLimited investigationFinal reportPitcher W-8 · Mineral, VAan electrical system problem that resulted in a blown (failed) fuze and an inoperative electric fuel pump, which in turn resulted in fuel starvation and loss of engine power; and failure of the pilot to maintain adequate airspeed which resulted in an…May 20, 1995 · N13PE · Destroyed NTSB NYC93LA160Accident · No injuriesLimited investigationFinal reportAeronca 7EC · Moneta, VAThe pilot's loss of directional control after landing, resulting in a departure from the runway and a collision with trees.Aug 15, 1993 · N4306C · Substantial damage NTSB BFO88FA082Accident · 2 fatalField investigationFinal reportPiper J3C-65 · Orange, VAPilot initiated lift off before flying speed was gained and as a result the aircraft had a loss of aerodynamic lift and stalled on the initial takeoff climb. The pilot's inadequate inflight decision and failure to abort the takeoff are contributing factors.Sep 11, 1988 · N98121 · Destroyed NTSB IAD77FIA21Accident · No injuriesClosedPiper PA-18 · Midland, VAJul 12, 1977 · N9147D · Substantial damage NTSB IAD75FID06Accident · Minor injuriesClosedChampion 7FC · Martinsville, VASep 28, 1974 · N7591B · Substantial damage NTSB NYC72DID32Accident · No injuriesClosedAlon A2-A · King George, VAJun 4, 1972 · N5464F · Substantial damage NTSB IAD71FID03Accident · No injuriesClosedAlon A-2 · Disputanta, VAJul 20, 1970 · N6594Q · Substantial damage NTSB IAD70D0095Accident · No injuriesClosedAlon A-2 · Franklin, VAOct 4, 1969 · N6594Q · Substantial damage NTSB DIA69F0046Accident · No injuriesClosedAeronca 7CCM · Abingdon, VAJul 6, 1968 · N83249 · Destroyed NTSB DIA68F0154Accident · No injuriesClosedPiper PA-18 · Brookneal, VAJan 25, 1968 · N2979Z · Substantial damage NTSB DIA67F0036Accident · Minor injuriesClosedAlon A-2 · Chesapeake, VAFeb 8, 1967 · N6581Q · Substantial damage NTSB NYC67D0056Accident · No injuriesClosedAlon A-2 · Hopewell, VAJul 9, 1966 · N6506Q · Substantial damage NTSB NYC66F0320Accident · No injuriesClosedPiper PA-18 · Brookneal, VAOct 24, 1965 · N2979Z · Substantial damage NTSB UNK65X1287Accident · No injuriesClosedLuscombe 8F · Chesapeake, VAJan 14, 1965 · N1875B · Substantial damage NTSB UNK64X2103Accident · No injuriesClosedCessna 140 · Hillsboro, VAJun 4, 1964 · N2298V · Substantial damage