Skip to content

NTSB investigations: Continental C90 series, MO

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" = 'MO' 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\" = 'MO' 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" = 'MO' 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 GAA19CA170Accident · No injuriesData collectionFinal reportPiper PA 11 · Moberly, MOThe pilot's failure to maintain directional control during the landing roll in gusting wind conditions.Mar 15, 2019 · N4926M · Substantial damage NTSB CEN10CA313Accident · No injuriesData collectionFinal reportLuscombe 8F · Shell Knob, MOA total loss of engine power for undetermined reasons.Jun 10, 2010 · N9932C · Substantial damage NTSB CHI02LA204Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Farmington, MOThe locked brake and the aircraft control not being possible due to the locked brake.Jul 17, 2002 · N840B · Substantial damage NTSB CHI98FA299Accident · 2 fatalField investigationFinal reportCessna 140 · St. Joseph, MOthe pilot not maintaining a proper final approach glide path to avoid an encounter with wake turbulence. A factor in this accident was the pilot not being able to control the airplane after its encounter with wake turbulence.Aug 4, 1998 · N2364V · Destroyed NTSB CHI98LA143Accident · 2 fatalLimited investigationFinal reportAlon A-2 · Cedar Hills, MOthe failure of the pilot to maintain airplane control due to alcohol impairment.May 10, 1998 · N5482E · Destroyed NTSB CHI93LA369Accident · No injuriesLimited investigationFinal reportLuscombe 8F · Festus, MOa fatigue failure of the tailwheel spring.Sep 18, 1993 · N840B · Substantial damage NTSB CHI92LA200Accident · Minor injuriesLimited investigationFinal reportCessna 140A · Grain Valley, MOThe pilot's excessive application of wheel brakes after touchdown.Jul 4, 1992 · N9664A · Substantial damage NTSB MKC88LA123Accident · No injuriesLimited investigationFinal reportAeronca 7EC · St. Charles, MOThe plt said he was taxiing out for departure, when he collided with another aircraft that was taxiing in from a local flight. He said he was intending to make an intersection takeoff and failed to see the incoming aircraft in time to avoid a collision.Jul 10, 1988 · N82994 · 2 aircraft · Substantial damage NTSB MKC80DCA25Accident · No injuriesClosedLuscombe 8F · Sullivan, MOJul 27, 1980 · N9930C · Substantial damage NTSB MKC78FCA02Accident · Serious injuriesClosedCessna 140A · Washington, MOOct 19, 1977 · N9445A · Destroyed NTSB MKC77DCG44Accident · No injuriesClosedAlon A2 · Grant City, MOJul 29, 1977 · N6555Q · Substantial damage NTSB MKC72DCA24Accident · No injuriesClosedChampion 7FC · Cape Girardeau, MOApr 6, 1972 · N4884E · Substantial damage NTSB MKC71DCG25Accident · No injuriesClosedPiper J3C-65 · Fairfax, MOAug 31, 1970 · N92226 · Substantial damage NTSB MKC70D0188Accident · Minor injuriesClosedAlon A-2 · Maryville, MOJul 23, 1969 · N6588Q · Substantial damage NTSB MKC68D0219Accident · No injuriesClosedCessna 140A · Pittsville, MOSep 6, 1967 · N5621C · Substantial damage NTSB MKC67D0249Accident · No injuriesClosedAeronca 7FC · Sikeston, MOSep 24, 1966 · N4870E · Substantial damage NTSB MKC66D0519Accident · No injuriesClosedLuscombe 8E · St. Charles, MOApr 2, 1966 · N2960K · Substantial damage NTSB MKC66F0002Accident · No injuriesClosedCessna 140 · Columbia, MOMay 17, 1965 · N2344V · Substantial damage NTSB MKC65D0081Accident · Minor injuriesClosedChampion 7FC · Faucett, MOApr 22, 1965 · N8539E · Substantial damage NTSB UNK65X0112Accident · Minor injuriesClosedPiper PA11 · Jasper, MOOct 2, 1964 · N4977H · Substantial damage