NTSB investigations: Continental O-470 series, 1996

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

19822026
NTSB investigations: Continental O-470 series, 1996 per year, 1982–2026: 105 cases
19827
198310
19846
19852
19865
19876
19884
19895
19901
19911
19927
19936
19946
19954
19965
19972
19982
19993
20001
20012
20023
20035
20042
20053
20064
20073

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 year(c.\"eventDate\") = 1996
    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\" = 340))
  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 LAX97LA062Accident · No injuriesLimited investigationFinal reportCessna 182M · Fallbrook, CAthe pilot's selection of a runway with a tailwind component and his maintaining an excessive airspeed on final approach, which resulted in a late touchdown and a high ground speed.Nov 28, 1996 · N70967 · Substantial damageNTSB NYC96LA185Accident · No injuriesLimited investigationFinal reportCessna 182 · Stow, MAthe pilot's misjudgment of speed and distance during the landing, and his failure to go around while there was sufficient runway remaining, which resulted in a runway overrun and an encounter with a soft terrain at the edge of a pond. Wet grass on the runway…Sep 16, 1996 · N737MD · Substantial damageNTSB SEA96LA099Accident · No injuriesLimited investigationFinal reportCessna 180 · Grangeville, IDthe pilot's failure to properly judge the distance and speed of the airplane during the final approach, his failure to obtain a proper touchdown point for landing, and his failure to perform a go-around, while there was sufficient runway remaining. A factor…May 26, 1996 · N626RP · Substantial damageNTSB IAD96LA062Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Saluda, VAwas the pilot's failure to follow the manufacturer's recommended approach reference speed (VREF) during the approach.Apr 14, 1996 · N1356S · Substantial damageNTSB FTW96LA099Accident · No injuriesLimited investigationFinal reportCessna 182K · Covington, LAthe pilot's delayed touchdown which resulted in a landing with inadequate runway remaining under the wet runway condition. A factor was the wet grass runway.Jan 16, 1996 · N3098Q · Substantial damage