Skip to content

NTSB investigations: Continental I0-470 series, LA

37 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" = '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 ('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\" = '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 ('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" = '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 ('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 CEN25LA169Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 182P · Kentwood, LAOn May 3, 2025, about 1530 central daylight time, a Cessna 182P, N9415M, was substantially damaged when it was involved in an accident near Kentwood, Louisiana. The pilot sustained serious injuries, and the passenger sustained minor injuries. The airplane was…May 3, 2025 · N9415M · Substantial damage NTSB CEN17LA157Accident · No injuriesLimited investigationFinal reportCessna 210 · Minden, LAThe pilot's inadequate fuel planning and in-flight fuel monitoring, which resulted in a total loss of engine power due to fuel exhaustion.Apr 15, 2017 · N7358E · Substantial damage NTSB DFW05FA055Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Patterson, LAThe pilot's failure to follow check-list procedures and the required placard instructions, which resulted in the fuel selectors being selected to the improper fuel tanks for take-off, resulting in a loss of engine power to the left engine. Also causal was the…Jan 14, 2005 · N7912R · Substantial damage NTSB FTW03FA225Accident · 2 fatalField investigationFinal reportCessna 310J · New Orleans, LAThe pilot's failure to maintain aircraft control of the airplane during a go-around. A contributing factor was the crosswind.Sep 15, 2003 · N2010E · Destroyed NTSB FTW93LA154Accident · Serious injuriesLimited investigationFinal reportCessna 310D · Roseland, LAThe pilot's failure to refuel resulting in loss of engine power due to fuel exhaustion. The lack of suitable terrain for the forced landing was a factor in the accident.May 14, 1993 · N407CS · Substantial damage NTSB FTW83LA289Accident · No injuriesLimited investigationFinal reportBeech 95-B55 · Pineville, LAPrior to landing, the plt moved the gear switch to the extend position & noted that the gear indicated down. However, the left main gear did not extend. While landing with the left gear retracted, the acft settled on the left wing & prop. The acft spun 180…Jun 20, 1983 · N7712R · Substantial damage NTSB FTW83LA021Accident · Minor injuriesLimited investigationFinal reportCessna 310C · Bastrop, LAThe pilot was preparing for an enroute landing when he got an unsafe gear light. While trouble-shooting, the left engine stopped. He feathered the left engine and almost immediately the right engine quit. The pilot failed to reach therunway during the power…Oct 24, 1982 · N1739H · Destroyed NTSB FTW82DA059Accident · No injuriesFinal reportCessna 310D · Farmerville, LABefore this flight, the aircraft had not been flown for a period of time. The pilot was the owner of a maintenance facility and was preparing to perform an annual inspection of the aircraft. He elected to fly it around the airport to warm up the engines…Feb 15, 1982 · N6822T · Destroyed NTSB FTW80FRJ06Accident · No injuriesClosedCessna 310P · Shreveport, LAOct 25, 1979 · N5911M · Substantial damage NTSB FTW76AF061Accident · 2 fatalClosedCessna 210 · Jena, LAJan 25, 1976 · N9490T · Destroyed NTSB FTW75FRD14Accident · Minor injuriesClosedBeech 35-B33 · Belle Chasse, LAOct 27, 1974 · N460SR · Substantial damage NTSB FTW73DRJ22Accident · No injuriesClosedCessna 205 · Bonita, LANov 15, 1972 · N511RJ · Substantial damage NTSB FTW69F0350Accident · No injuriesClosedBeech M35 · Pineville-La, LAJan 2, 1969 · N9310Y · Substantial damage NTSB FTW68F0620Accident · No injuriesClosedCessna 310 · Freemason Isle, LAJun 23, 1968 · N6939T · Substantial damage NTSB FTW68F0299Accident · No injuriesClosedBellanca 14-193 · Kenner, LAOct 21, 1967 · N8515R · Substantial damage NTSB FTW68F0316Accident · No injuriesClosedCessna 210 · Shreveport, LASep 8, 1967 · N215MD · Substantial damage NTSB FTW68F0219Accident · No injuriesClosedBeech P35 · Shreveport, LASep 4, 1967 · N9545Y · Substantial damage NTSB FTW68D0049Accident · No injuriesClosedCessna 185C · New Iberia, LAJul 18, 1967 · N2679Z · Substantial damage NTSB FTW68D0022Accident · No injuriesClosedCessna 210 · Rayville, LAMay 29, 1967 · N6678X · Substantial damage NTSB FTW67F0617Accident · No injuriesClosedCessna 185C · Houma, LAMay 18, 1967 · N5831T · Substantial damage NTSB FTW67D0321Accident · No injuriesClosedCessna 310" · Houma, LANov 30, 1966 · N6686B · Substantial damage NTSB FTW67D0288Accident · No injuriesClosedCessna 210A · New Orleans, LAOct 14, 1966 · N6685X · Substantial damage NTSB FTW67F0124Accident · No injuriesClosedBeech 95-B55 · Shreveport, LAJul 26, 1966 · N275D · Substantial damage NTSB FTW67F0052Accident · No injuriesClosedBeech M35 · Shreveport, LAJul 2, 1966 · N9734R · Substantial damage NTSB FTW66D0706Accident · No injuriesClosedCessna 210 · Lafayette, LAJun 4, 1966 · N9675X · Substantial damage NTSB FTW66D0558Accident · No injuriesClosedCessna 185 · Baton Rouge, LAMar 17, 1966 · N1573F · Substantial damage NTSB FTW66F0576Accident · No injuriesClosedBeechcraft P35 · Lake Charles, LAMar 12, 1966 · N1555Z · Substantial damage NTSB FTW66F0547Accident · No injuriesClosedCessna 185C · Morgan City, LAFeb 26, 1966 · N2673Z · Substantial damage NTSB FTW66D0451Accident · No injuriesClosedCessna 310D · Thornwell, LADec 20, 1965 · N6899T · Substantial damage NTSB FTW66D0324Accident · No injuriesClosedCessna 185 · Baton Rouge, LASep 25, 1965 · N5885T · Substantial damage NTSB FTW66F0129Accident · Minor injuriesClosedCessna 210-5A · Sicily Island, LAJul 13, 1965 · N4832U · Substantial damage NTSB FTW65F0006Accident · Serious injuriesClosedGrumman G-44A · Abbeville, LAApr 16, 1965 · N86627 · Minor damage NTSB FTW65F0043Accident · No injuriesClosedBeechcraft M-35 · New Orleans, LAApr 7, 1965 · N9734R · Substantial damage NTSB UNK65X1424Accident · No injuriesClosedCessna 210 · Baton Rouge, LAFeb 15, 1965 · N9673T · Substantial damage NTSB UNK65X1321Accident · No injuriesClosedCessna 310I · Monroe, LAJan 20, 1965 · N8088M · Substantial damage NTSB UNK64X2265Accident · No injuriesClosedCessna 210 · Shreveport, LAJun 13, 1964 · N7302E · Substantial damage NTSB UNK64X0182Accident · No injuriesClosedBeechcraft B95A55 · New Orleans, LAJan 7, 1964 · N1726G · Substantial damage