Skip to content

NTSB investigations: Continental I0-470 series, AL

30 cases on aircraft whose registry engine model is Continental I0-470 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" = 'AL' 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 ('17027')) 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\" = 'AL' 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 ('17027'))
  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" = 'AL' 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 ('17027'))
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 ERA25LA269Accident · Serious injuriesClass 3 · LimitedPreliminary reportBeech K35 · Sylacauga, ALOn July 16, 2025, at 1402 central standard time, a Beech K35, N5353E, was substantially damaged when it was involved in an accident near Sylacauga, Alabama. The private pilot sustained serious injuries. The airplane was operated as a Title 14 Code of Federal…Jul 16, 2025 · N5353E · Substantial damage NTSB ERA18FA146Accident · 1 fatalField investigationFinal reportBeech 35A33 · Jacksonville, ALThe pilot/mechanic's inadequate inspection of the exhaust system, including the left muffler and heat exchanger, which precluded his detection of preexisting cracks and led to a missed opportunity to replace the components. The inadequate inspection allowed…May 13, 2018 · N486T · Destroyed NTSB ERA14LA324Accident · No injuriesLimited investigationFinal reportBeech 95 55 · Gulf Shores, ALThe pilot’s improper landing flare, which resulted in a hard landing.Jun 26, 2014 · N9411Y · Substantial damage NTSB NYC08FA231Accident · 4 fatalField investigationFinal reportBeech 95-B55 · Jasper, ALThe pilot's intentional visual flight into known instrument meteorological conditions, resulting in spatial disorientation and a subsequent loss of control in flight. Contributing to the accident was the overweight and aft-center-of-gravity condition of the…Jun 29, 2008 · N727BC · Destroyed NTSB MIA00FA166Accident · 1 fatalField investigationFinal reportBeech 95-A55 · Aliceville, ALThe in-flight collision with trees then terrain while descending for undetermined reasons.May 23, 2000 · N711MS · Destroyed NTSB ATL98LA048Accident · No injuriesLimited investigationFinal reportCessna 210 · Hazel Green, ALthe pilot's improper flare, which resulted in a hard landing and the nose gear collapsing.Feb 21, 1998 · N7398E · Substantial damage NTSB ATL89LA034Accident · Minor injuriesLimited investigationFinal reportCessna 210B · Uriah, ALWhile cruising at 6500 ft, the eng lost power & the prop stopped windmilling. The plt elected to land on a highway. Drg the landing, the right wing hit overhanging tree limbs which yawed the acft off the right side of the road & down an embankment. The eng…Nov 17, 1988 · N5021P · Substantial damage NTSB ATL86FA063Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Anniston, ALThe acft was observed flying through the base of the low level cloud layer prior to its impact on the side of a mountain. The plt was not instrument rated, had not filed a flt plan nor obtained a wx briefing. The impact point was several hundred ft below the…Jan 22, 1986 · N7948K · Destroyed NTSB ATL83FA129Accident · 2 fatalField investigationFinal reportBeech K35 · Birmingham, ALThe acft collided with trees and terrain during a practice localizer approach at night to rwy 23 at Birmingham municipalarpt. The weather was VMC and the pilot was not instrument rated. On approaching Birmingham from tri-cities, NC the pilot asked for a…Mar 7, 1983 · N9543R · Destroyed NTSB ATL82DKJ09Accident · No injuriesFinal reportCessna 310L · Auburn, ALThe pilot tookoff from north huntsville on a runway that was wet from melted snow. After takeoff, the gear would not retract, so he returned and landed. A mechanic found ice on the anti-retraction switch on the left main gear. A ground heater was used to melt…Jan 11, 1982 · N424VW · Substantial damage NTSB ATL81FKJ35Accident · No injuriesClosedBellanca 14-19 · Weaver, ALSep 12, 1981 · N36KC · Substantial damage NTSB ATL81FKJ12Accident · No injuriesClosedBeech K35 · Wetumpka, ALFeb 26, 1981 · N133VW · Substantial damage NTSB MIA80FKJ34Accident · No injuriesClosedBeech 95-B55 · Montgomery, ALApr 10, 1980 · N75RA · Substantial damage NTSB MIA80FKJ07Accident · No injuriesClosedCessna 210 · Birmingham, ALOct 28, 1979 · N6638X · Substantial damage NTSB MIA79FKJ48Accident · No injuriesClosedCessna 310 · Birmingham, ALJul 3, 1979 · N4169Q · Substantial damage NTSB MIA78DKJ10Accident · No injuriesClosedBeech J35 · Huntsville, ALNov 16, 1977 · N8318D · Substantial damage NTSB MIA75DKJ47Accident · No injuriesClosedRepublic RC-3 · Bayou La Barte, ALMar 20, 1975 · N6432K · Substantial damage NTSB MIA72FKJ48Accident · No injuriesClosedBeech 55 · Birmingham, ALApr 1, 1972 · N661MW · Substantial damage NTSB MIA72DKJ28Accident · No injuriesClosedCessna 310 · Troy, ALOct 12, 1971 · N8988Z · Substantial damage NTSB MIA71FKJ64Accident · No injuriesClosedCessna 210 · Maxwell Afb, ALJun 24, 1971 · N9490T · Substantial damage NTSB MIA71FKJ42Accident · Serious injuriesClosedCessna 150 · Hatchechubbee, ALMar 18, 1971 · N3946U · Substantial damage NTSB MIA70FKJ13Accident · No injuriesClosedBeech BE33 · Alabaster, ALFeb 21, 1970 · N919T · Substantial damage NTSB MIA70D0110Accident · No injuriesClosedCessna 210 · Decatur, ALJul 12, 1969 · N7398E · Substantial damage NTSB MIA69F0188Accident · No injuriesClosedBeech 35-C33 · Birmingham, ALSep 26, 1968 · N5808K · Substantial damage NTSB MIA69D0044Accident · No injuriesClosedBeech J35 · Clanton, ALJul 4, 1968 · N8309D · Substantial damage NTSB MIA68F0408Accident · No injuriesClosedCessna 310K · Guntersville, ALJan 13, 1968 · N7023L · Substantial damage NTSB MIA67F0443Accident · No injuriesClosedCessna 210 · Selma, ALMar 18, 1967 · N9694T · Substantial damage NTSB MIA67F0398Accident · No injuriesClosedBeech 95-A55 · Bessemer, ALDec 26, 1966 · N1449G · Substantial damage NTSB UNK64X3478Accident · No injuriesClosedCessna 310H · Birmingham, ALAug 19, 1964 · N1052Q · Substantial damage NTSB UNK64X2838Accident · No injuriesClosedCessna 205 · Anniston, ALJul 15, 1964 · N4834U · Substantial damage