Skip to content

NTSB investigations: Continental I0-470 series, NE

35 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

19652026

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" = 'NE' 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\" = 'NE' 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" = 'NE' 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 CEN25FA348Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 210D · Kearney, NEOn August 27, 2025, about 20:57 central daylight time, a Cessna 210D, N3806Y was destroyed when it was involved in an accident near Kearney, Nebraska. Both pilots were fatally injured. The flight was operated under the provisions of Title 14 Code of Federal…Aug 28, 2025 · N3806Y · Substantial damage NTSB CEN22FA023Accident · 2 fatalClass 3 · FieldFinal reportBeech P35 · Harrison, NEThe pilot’s decision to continue the flight into instrument and icing conditions, which resulted in loss of control and impact with terrain. Contributing to the accident was the pilot’s failure to obtain a timely weather briefing.Oct 31, 2021 · N8625M · Substantial damage NTSB CEN19FA236Accident · 3 fatalClass 2 · FieldFinal reportBeech 95B55 · Chadron, NEThe pilot's failure to ensure adequate fuel was on board before departing and his in-flight fuel management, which resulted in a total loss of engine power due to fuel exhaustion.Jul 24, 2019 · N8910U · Substantial damage NTSB CEN18FA193Accident · 2 fatalField investigationFinal reportBeech P35 · Omaha, NEThe pilot's loss of directional control and his failure to abort the takeoff, which resulted in a runway excursion and collision with terrain.May 27, 2018 · N263CE · Destroyed NTSB CEN16FA005Accident · 1 fatalField investigationFinal reportBeech P35 · Chadron, NEThe pilot's continued visual flight rules flight into instrument meteorological conditions, which resulted in controlled flight into rising terrain during cruise flight.Oct 6, 2015 · N877DM · Destroyed NTSB CHI06CA169Accident · Serious injuriesData collectionFinal reportBeech 35-33 · Lincoln, NEA loss of engine power due to fuel exhaustion as a result of inaccurate fuel consumption calculations and inadequate monitoring of the remaining fuel quantity en route. A contributing factor was the inadequate supervision of the instructional flight by the…Jun 26, 2006 · N983T · Substantial damage NTSB CHI01LA090Accident · No injuriesLimited investigationFinal reportBeech 95-55 · Scottsbluff, NEthe checklist not followed and the wheels-up landing performed by the pilot. The runway light was a contributing factor.Feb 15, 2001 · N98PA · Substantial damage NTSB CHI99LA272Accident · No injuriesLimited investigationFinal reportBellanca 14-19 · North Platte, NEThe pilot's improper inflight planning decision which resulted in fuel exhaustion. A factor associated with the accident was the dark night conditions.Aug 2, 1999 · N8509R · Substantial damage NTSB MKC77DCJ46Accident · No injuriesClosedBeech 35-C33 · Mccook, NESep 10, 1977 · N887R · Substantial damage NTSB MKC77DCJ12Accident · No injuriesClosedCessna 185 · Lincoln, NEMar 6, 1977 · N9885X · Substantial damage NTSB MKC76DCJ42Accident · No injuriesClosedCessna 210 · Omaha, NEJun 19, 1976 · N9488T · Substantial damage NTSB MKC76DCJ36Accident · No injuriesClosedCessna 185D · Ashby, NEMay 25, 1976 · N5700M · Substantial damage NTSB MKC76FCJ28Accident · No injuriesClosedBeech F33A · Central City, NEMar 6, 1976 · N9005V · Substantial damage NTSB MKC75FCJ39Accident · No injuriesClosedCessna 310H · Millard, NENov 19, 1974 · N1099Q · Substantial damage NTSB MKC75DCJ40Accident · No injuriesClosedCessna 210 · Hyannis, NEMay 12, 1974 · N9622T · Substantial damage NTSB MKC74DCJ02Accident · No injuriesClosedBeech P35 · Scottsbluff, NEJul 14, 1973 · N525KG · Substantial damage NTSB MKC73FCJ31Accident · No injuriesClosedCessna 310G · Omaha, NEMar 6, 1973 · N2909R · Substantial damage NTSB MKC73DCJ03Accident · No injuriesClosedCessna 185 · Geneva, NEJul 9, 1972 · N4061Y · Substantial damage NTSB MKC72DCJ05Accident · No injuriesClosedCessna 310G · Columbus, NEJul 10, 1971 · N8957Z · Substantial damage NTSB MKC71FCJ72Accident · No injuriesClosedBeech P35 · Chambers, NEJun 7, 1971 · N8677M · Substantial damage NTSB MKC70D0296Accident · No injuriesClosedCessna 310D · Omaha, NEDec 11, 1969 · N6933T · Substantial damage NTSB MKC69F0319Accident · No injuriesClosedCessna 210 · Omaha, NEJan 10, 1969 · N9446T · Substantial damage NTSB MKC69D0121Accident · No injuriesClosedCessna 210 · York, NEJul 23, 1968 · N9454T · Substantial damage NTSB MKC69F0039Accident · No injuriesClosedBellanca 14-19 · Falls City, NEJul 13, 1968 · N8543R · Substantial damage NTSB MKC68F0574Accident · No injuriesClosedBeech 95B55 · Scottsbluff, NEMay 9, 1968 · N5896J · Substantial damage NTSB MKC68D0523Accident · No injuriesClosedBeech 95-B55 · Norfolk, NEApr 7, 1968 · N6220V · Substantial damage NTSB MKC68F0332Accident · No injuriesClosedCessna 310 · Alliance, NENov 5, 1967 · N310S · Substantial damage NTSB MKC68D0050Accident · No injuriesClosedBeech 35-B33 · Campbell, NEJun 17, 1967 · N433T · Substantial damage NTSB MKC67D0618Accident · No injuriesClosedBeech 95-55 · Omaha, NEMay 8, 1967 · N1711V · Substantial damage NTSB MKC67F0198Accident · No injuriesClosedBeech K35 · Lincoln, NESep 24, 1966 · N9508R · Substantial damage NTSB MKC66F0571Accident · No injuriesClosedBeech N35 · Broken Bow, NEMay 20, 1966 · N545T · Substantial damage NTSB MKC66F0484Accident · No injuriesClosedBeech N35 · Kearney, NEApr 3, 1966 · N953T · Substantial damage NTSB MKC66F0431Accident · No injuriesClosedBeech 35-33 · Omaha, NEMar 14, 1966 · N869R · Substantial damage NTSB MKC66F0259Accident · No injuriesClosedCessna 210 · Omaha, NEOct 9, 1965 · N6545X · Substantial damage NTSB MKC66F0192Accident · No injuriesClosedCessna 185 · Fairbury, NEAug 27, 1965 · N9852X · Substantial damage