Skip to content

NTSB investigations: Continental C90 series, LA

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" = 'LA' 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\" = 'LA' 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" = 'LA' 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 CEN22LA139Accident · Serious injuriesClass 4 · LimitedFinal reportAeronca 7CCM · Winnsboro, LAThe pilot’s loss of airplane control during takeoff and subsequent impact with trees and terrain. Contributing to the accident was the pilot’s lack of experience in the accident airplane.Mar 4, 2022 · N555EK · Substantial damage NTSB CEN19LA206Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 140 · Reeves, LAThe pilot's failure to secure the oil filler cap, which resulted in oil starvation and a precautionary off-airport landing, during which the airplane was substantially damaged.Jul 4, 2019 · N3725V · Substantial damage NTSB FTW88DRD20Accident · 1 fatalFinal reportAlon A2A · New Orleans, LAThe highly modified airplane was observed in a near vertical dive before it impacted into a marsh. No mechanical or medical reasons were found for the crash. Although toxicological analysis indicated a blood alcohol level of .11%, there was evidence of…Aug 24, 1988 · N5626F · Destroyed NTSB FTW85FRD01Accident · Serious injuriesFinal reportAlon A-2 · Bunkie, LAThe acft contacted the terrain and was destroyed by fire following a loss of elevator and aileron control. The plt reported he maintained control of the acft by use of the rudder, pwr and elevator trim. Post accident inspection revealed the left aileron…May 5, 1985 · N5491E · Destroyed NTSB FTW83LA036Accident · No injuriesLimited investigationFinal reportChampion 7FC · Alexandria, LADuring landing, the aircraft touched down with a right quartering tailwind. The pilot stated that after making a normal approach and landing, he overcontrolled the rudder. The aircraft veer off the runway and collided with a ditch before reaching the taxiway.…Nov 14, 1982 · N7682E · Substantial damage NTSB FTW78FRD49Accident · Serious injuriesClosedPiper J-3 · Welsh, LAAug 7, 1978 · N3683K · Destroyed NTSB FTW78FRJ22Accident · No injuriesClosedChampion 7EC · Waverly, LAJun 14, 1978 · N9849Y · Destroyed NTSB FTW77FRD34Accident · Minor injuriesClosedChampion 7FC · Kinder, LAJun 10, 1977 · N9856Y · Substantial damage NTSB FTW74DRJ16Accident · No injuriesClosedLuscombe 8F · Kilbourne, LAOct 1, 1973 · N2129B · Substantial damage NTSB FTW69D0211Accident · No injuriesClosedChampion 7FC · Collinston, LASep 21, 1968 · N7532E · Substantial damage NTSB FTW69F0001Accident · No injuriesClosedChampion 7FC · Oak Grove, LAMay 5, 1968 · N4851E · Substantial damage NTSB FTW68F0221Accident · No injuriesClosedLuscombe 8F · Lafayette, LASep 9, 1967 · N9916C · Substantial damage NTSB FTW67F0235Accident · No injuriesClosedErcoupe 415-C · Shreveport, LASep 21, 1966 · N99649 · Substantial damage NTSB FTW67D0201Accident · No injuriesClosedCessna 140A · Springhill, LASep 11, 1966 · N5317C · Substantial damage NTSB FTW66F0579Accident · No injuriesClosedPiper PA-18 · Oak Grove, LAMar 19, 1966 · N8176D · Substantial damage NTSB FTW66F0537Accident · No injuriesClosedChampion 7FC · Kaplan, LAMar 15, 1966 · N4851E · Substantial damage NTSB FTW66D0407Accident · No injuriesClosedPiper PA-18 · Timbalier Bay, LANov 13, 1965 · N3690P · Substantial damage NTSB FTW66F0167Accident · No injuriesClosedPiper PA-18 · Oak Grove, LAJul 25, 1965 · N8059C · Substantial damage NTSB UNK64X2681Accident · No injuriesClosedChampion 7FC · Kaplan, LAJul 6, 1964 · N4851E · Destroyed NTSB UNK64X0364Accident · No injuriesClosedChampion 7EC · Slidell, LAJan 26, 1964 · N7506B · Substantial damage