NTSB investigations: Continental O-470 series, TX

10 cases on aircraft whose registry engine model is Continental O-470 series, where the first occurrence was “Loss of engine power”. 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

19832026
NTSB investigations: Continental O-470 series, TX per year, 1983–2026: 10 cases
19831
19861
19922
19931
19941
19992
20012

Latest 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.\"eventStateOrRegion\" = 'TX' 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 ('17026')
      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\" = 350))
  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.

NTSB FTW01LA200Accident · No injuriesLimited investigationFinal reportCessna 182A · Salado, TXA loss of engine power for undetermined reasons. A factor was the pilot's failure to maintain airspeed during the forced landing resulting in a stall. This report was modified on December 2, 2005.Aug 18, 2001 · N4795D · Substantial damageNTSB FTW01LA130Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Hondo, TXthe pilot's inadequate preflight of the airplane, which resulted in a loss of engine power in cruise flight due to water in the fuel. A contributing factor was the soft terrain encountered during the forced landing.May 27, 2001 · N9875E · Substantial damageNTSB FTW99FA261Accident · 5 fatalField investigationFinal reportCessna 182A · Bryan, TXthe pilot's failure to maintain aircraft control resulting in an inadvertent stall. A factor was the loss of engine power as a result of fatigue cracking and separation of the #6 cylinder head.Sep 18, 1999 · N4803D · DestroyedNTSB FTW99LA070Accident · No injuriesLimited investigationFinal reportCessna 180J · Granbury, TXThe loss of engine power due to an undetermined reason. A factor was the power lines crossing the final approach path.Jan 23, 1999 · N52170 · Substantial damageNTSB FTW94LA112Accident · No injuriesLimited investigationFinal reportCessna 180 · Austin, TXThe loss of engine power for undetermined reasons. Factors were the wire strike and lack of suitable terrain.Mar 30, 1994 · N4646B · Substantial damageNTSB FTW94LA051Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Dalhart, TXThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.Dec 18, 1993 · N96591 · Substantial damageNTSB FTW92LA170Accident · No injuriesLimited investigationFinal reportCessna 182D · Beeville, TXEngine power loss for undetermined cause. A factor was the pilots' failure to lower flaps for the short field landing.Jun 6, 1992 · N8979X · Substantial damageNTSB FTW92LA105Accident · No injuriesLimited investigationFinal reportCessna 182A · Stanton, TXPower loss for undetermined reasons. A factor was soft terrain.Apr 4, 1992 · N2171G · Substantial damageNTSB FTW87LA030Accident · No injuriesLimited investigationFinal reportCessna 305A · Mason, TXPrivate pilot of Cessna 305A ferrying aircraft from glascow, MT. To mc allen TX. Engine failed approximately 1 1/2 hours after departure from graham TX. Pilot attempted downwind landing on farm-to-market road and struck tree. Aircraft was destroyed. Pilot and…Dec 9, 1986 · N5211G · DestroyedNTSB FTW83LA294Accident · No injuriesLimited investigationFinal reportRyan NAVION-A · Kenedy, TXAfter taking off, the eng began to lose power. The plt said it quit & restarted several times while he was trying to return to the arpt. During an emergency landing, about 3 mi from the arpt, the plt elected to land with the gear retracted since there were…Jun 27, 1983 · N5040K · Substantial damage