Skip to content

NTSB investigations: Continental C90 series, PA

27 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" = 'PA' 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\" = 'PA' 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" = 'PA' 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 ERA25LA030Accident · No injuriesClass 3 · LimitedFinal reportZenith Zodiac 601 HDS · Altoona, PAThe total loss of engine power due to fuel starvation as a result of a deteriorated gascolator gasket. Contributing was the failure of the mechanic to replace the gasket during the most recent condition inspection.Oct 17, 2024 · N511JG · Substantial damage NTSB ERA12CA269Accident · No injuriesData collectionFinal reportLuscombe 8A · Pittsburgh, PAThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion.Apr 3, 2012 · N71479 · Substantial damage NTSB ERA11CA366Accident · No injuriesData collectionFinal reportChampion 7FC · Wellsville, PAThe pilot's failure to maintain adequate airspeed on final approach which resulted in an aerodynamic stall.Jun 18, 2011 · N7583E · Substantial damage 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.Aug 5, 2006 · N9866B · Substantial damage NTSB NYC00LA185Accident · No injuriesLimited investigationFinal reportErcoupe Forney F-1 · Leechburg, PAA severed oil pressure line, which resulted in an off airport landing.Jul 9, 2000 · N7518C · Substantial damage NTSB NYC97LA114Accident · No injuriesLimited investigationFinal reportLuscombe 8F · New Town, PAThe pilot's improper fuel management, which resulted in an intermittent fuel supply, and a loss of engine power.Jun 15, 1997 · N1894B · Substantial damage NTSB NYC96LA112Accident · No injuriesLimited investigationFinal reportAeronca 7EC · New Castle, PAthe pilot's failure to maintain directional control during the landing roll, which resulted in a ground swerve and an encounter with high grass and a ditch off the side of the runway.May 21, 1996 · N1536E · Substantial damage NTSB NYC77FGM21Accident · No injuriesClosedAlon A-2 · Beaver Falls, PAMay 7, 1977 · N5470E · Substantial damage NTSB NYC77DGM01Accident · Minor injuriesClosedPiper PA-18 · Emporium, PAOct 5, 1976 · N8787D · Substantial damage NTSB NYC76DHA14Accident · Minor injuriesClosedCessna 140 · New Milford, PAOct 1, 1975 · N2187V · Substantial damage NTSB NYC74FGT18Accident · Minor injuriesClosedForney F-1 · Shippensburg, PAApr 28, 1974 · N3003G · Substantial damage NTSB NYC74FHA14Accident · No injuriesClosedErco 415-D · Tunkhannock, PAOct 20, 1973 · N2396H · Substantial damage NTSB NYC73DHD28Accident · No injuriesClosedChampion 7EC · Ambler, PAMar 23, 1973 · N7420B · Substantial damage NTSB NYC72FGT04Accident · No injuriesClosedWhittman W-8 · Halifax, PAAug 1, 1971 · N1111N · Substantial damage NTSB NYC72FGM05Accident · No injuriesClosedAeronca 7CCM · Irwin, PAJul 25, 1971 · N4635E · Substantial damage NTSB NYC71FHA47Accident · No injuriesClosedChampion 7FC · Kutztown, PAMay 15, 1971 · N7570B · Substantial damage NTSB NYC71FHG10Accident · No injuriesClosedPiper PA-18C · Annville, PAOct 24, 1970 · N4068A · Substantial damage NTSB NYC69F0402Accident · Minor injuriesClosedCessna 140A · Coudersport, PAApr 13, 1969 · N3780V · Substantial damage NTSB NYC67D0513Accident · No injuriesClosedChampion 7FC · Philadelphia, PAJan 29, 1967 · N7566E · Substantial damage NTSB NYC67F0035Accident · No injuriesClosedLuscombe 8F · West Mifflin, PAMay 27, 1966 · N1544B · Substantial damage NTSB NYC66F0221Accident · No injuriesClosedPiper J3C · Monroeville, PASep 3, 1965 · N98679 · Substantial damage NTSB NYC65F0190Accident · Serious injuriesClosedAeronca 7CCM · Ebensburg, PAApr 20, 1965 · N4635E · Substantial damage NTSB NYC65D0139Accident · No injuriesClosedChampion 7FC · Warren, PAFeb 6, 1965 · N7513E · Substantial damage NTSB UNK65X0895Accident · No injuriesClosedChampion 7FC · Berwick, PADec 1, 1964 · N9050B · Substantial damage NTSB UNK64X3406Accident · Serious injuriesClosedPiper J3 · Monroeville, PAAug 15, 1964 · N98679 · Substantial damage NTSB UNK64X3393Accident · No injuriesClosedSilvaire 8F · Cambridge, PAAug 15, 1964 · N9936C · Substantial damage NTSB UNK64X0926Accident · No injuriesClosedChampion 7FC · Sharon, PAMar 15, 1964 · N8513E · Substantial damage