Skip to content

NTSB investigations: Continental I0-470 series, MA

24 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

19662026

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" = 'MA' 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\" = 'MA' 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" = 'MA' 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 ERA24FA088Accident · 3 fatalClass 3 · FieldFinal reportBeech 95-B55 (T42A) · Leyden, MAThe flight instructor’s failure to maintain airplane control during a stall, which resulted in an inadvertent spin from which the airplane was not recovered. Contributing to the accident were the overall effect of the flight instructor’s use of multiple…Jan 14, 2024 · N7345R · Substantial damage NTSB ERA21LA093Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-B55 (T42A) · Westfield, MAThe pilot’s failure to maintain control of the airplane during the landing and his failure to confirm that the landing gear was extended before landing.Dec 29, 2020 · N916MT · Substantial damage NTSB ERA11FA102Accident · 1 fatalField investigationFinal reportCessna 310F · Orange, MAThe pilot did not maintain separation from trees during landing. Contributing to the accident was the pilot’s inadequate preflight planning and lack of recent night flight experience.Jan 1, 2011 · N6725X · Substantial damage NTSB NYC06CA023Accident · No injuriesData collectionFinal reportBeech M35 · Pittsfield, MAThe pilot's inadvertent retraction of the landing gear during the landing roll.Oct 28, 2005 · N120V · Substantial damage NTSB NYC02FA032Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Falmouth, MAThe incapacitation of the pilot for undetermined reasons which resulted in an in-flight collision with water.Nov 21, 2001 · N3847Q · Destroyed NTSB NYC96LA141Accident · Minor injuriesLimited investigationFinal reportCessna 210 · Boston, MAa fracture failure of the crankcase, which resulted in separation of the number five cylinder, loss of engine power, and a ditched landing.Jul 5, 1996 · N131AC · Substantial damage NTSB NYC83LA247Accident · No injuriesLimited investigationFinal reportCessna 185B · Orange, MADuring arrival, the plt used a grass landing area on the north side of rwy 32/14. The wind had previously been from 290 deg, but had swung to 350 deg. The plt reported that he landed in a level attitude on the main gear, then reduced the throttle to idle.…Sep 18, 1983 · N11LP · Substantial damage NTSB NYC83LA075Accident · No injuriesLimited investigationFinal reportBeech P35 · Beverly, MAThe approach was made at 90 mph with full flaps in winds gusting to 25K. As the plt flared for landing the right gear contacted a pot hole at the approach lip of the rwy blowing the tire causing the rear strut to push a hole into the wing skin.Feb 24, 1983 · N972Q · Substantial damage NTSB NYC79FA009Accident · 3 fatalClosedCessna 310N · Monroe, MASep 25, 1978 · N4121Q · Destroyed NTSB NYC77FNA24Accident · No injuriesClosedCessna 310D · Norwood, MAJul 6, 1977 · N6758T · Substantial damage NTSB NYC73FNE36Accident · No injuriesClosedCessna 310Q · Westfield, MAJun 26, 1973 · N7667Q · Substantial damage NTSB NYC73FNA50Accident · No injuriesClosedCessna 310C · Hyannis, MAMay 30, 1973 · N6727T · Substantial damage NTSB NYC72FNA29Accident · No injuriesClosedCessna 310I · New Bedford, MAOct 25, 1972 · N922GB · Substantial damage NTSB NYC72FNA22Accident · No injuriesClosedBeech J35 · Bedford, MADec 4, 1971 · N636Q · Substantial damage NTSB NYC71FFD16Accident · No injuriesClosedBeech 95-B55 · Boston, MAOct 13, 1970 · N413J · Substantial damage NTSB NYC71AN019Accident · 3 fatalClosedCessna 205A · Chatham, MAAug 13, 1970 · N4869U · Substantial damage NTSB NYC71FFD06Accident · No injuriesClosedBeech 35B33 · Bedford, MAJul 27, 1970 · N5679K · Substantial damage NTSB NYC70DFD25Accident · No injuriesClosedBeech E33 · Edgartown, MAJun 28, 1970 · N8385N · Substantial damage NTSB NYC70FFM01Accident · No injuriesClosedBeech 35-C33 · Florida, MAJan 11, 1970 · N1941T · Substantial damage NTSB NYC70D0233Accident · No injuriesClosedBeech 35-C33 · East Boston, MANov 23, 1969 · N6037F · Substantial damage NTSB NYC69F0141Accident · No injuriesClosedBeech 95-B55 · Fitchburg, MAAug 22, 1968 · N620G · Substantial damage NTSB NYC68D0214Accident · No injuriesClosedCessna 310 · East Boston, MAOct 15, 1967 · N7079L · Substantial damage NTSB NYC67F0075Accident · No injuriesClosedCessna 210 · Gardner, MAJun 29, 1966 · N9635T · Substantial damage NTSB NYC67F0123Accident · No injuriesClosedBeech 95-B55 · Beverly, MAJun 15, 1966 · N781K · Substantial damage