Skip to content

NTSB investigations: Continental IO-520 series, MA

25 cases on aircraft whose registry engine model is Continental IO-520 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 ('17032')) 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 ('17032'))
  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 ('17032'))
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 ERA16LA115Accident · Serious injuriesLimited investigationFinal reportBeech 95 C55 · Plymouth, MAThe pilot's failure to maintain control of the airplane during an aborted takeoff in gusting wind conditions.Feb 27, 2016 · N482S · Substantial damage NTSB ERA13CA355Accident · No injuriesData collectionFinal reportBeech 58 · New Bedford, MAThe pilot's improper decision to land in the displaced threshold, resulting in a collision with the approach lighting system.Jul 31, 2013 · N58DL · Substantial damage NTSB ERA11CA262Accident · No injuriesData collectionFinal reportCessna U206G · Stow, MAThe pilot's inadequate compensation for the crosswind condition and his failure to maintain directional control during landing.Apr 24, 2011 · N304EB · Substantial damage NTSB ERA11FA078Accident · 2 fatalField investigationFinal reportCessna U206G · Leverett, MAA total loss of engine power due to the fatigue failure of the crankshaft, which resulted from improper tightening of the cylinder hold-down nuts.Dec 5, 2010 · N9742Z · Substantial damage NTSB ERA10LA317Accident · Serious injuriesLimited investigationFinal reportCessna 401 · Plymouth, MAA total loss of engine power during final approach due to fuel starvation as a result of the pilot’s delayed configuration of the airplane for landing.Jun 18, 2010 · N401TE · Substantial damage NTSB NYC02LA143Accident · No injuriesLimited investigationFinal reportBeech 58 · Provincetown, MAThe pilot's failure to initiate a timely go-around, which resulted in his landing the airplane long and fast. Factors included low ceilings and the airplane's initial misalignment with the runway.Jul 19, 2002 · N9280Q · Substantial damage NTSB IAD00LA045Accident · No injuriesLimited investigationFinal reportBeech A-36 · Bedford, MAthe pilot's improper fuel management which resulted in fuel starvation.May 27, 2000 · N66SB · Substantial damage NTSB IAD97LA093Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Charlton, MAThe loss of engine power for undetermined reasons..Jun 28, 1997 · N39CC · Substantial damage NTSB NYC94FA007Accident · 1 fatalField investigationFinal reportBeech A36 · Topsfield, MAFailure of the pilot to follow the published IFR procedure, and his failure to correct a spiral after becoming spatially disoriented.Oct 9, 1993 · N6AP · Destroyed NTSB BFO93LA114Accident · No injuriesLimited investigationFinal reportBeech A36 · Falmouth, MAThe pilot's inadequate compensation for wind conditions and improper recovery from a bounced landing. The gusty wind condition was a related factor.Jul 6, 1993 · N4325W · Substantial damage NTSB NYC90LA123Accident · No injuriesLimited investigationFinal reportCessna 401 · Plymouth, MAImproper maintenance and inspection by maintenance personnel of the left gear torque link attachment.May 31, 1990 · N401FC · Substantial damage NTSB NYC87LA026Accident · No injuriesLimited investigationFinal reportCessna U206F · Marshfiled, MAElectrical failure occurred in flight due to an alternator belt failure. The acft landed in the grass beside the rwy and was damaged. The landing was difficult due to darkness, fog and no lights. The plt tried to use flaps but failed due to no elec power. The…Oct 29, 1986 · N9585G · Substantial damage NTSB NYC86FA234Accident · Serious injuriesField investigationFinal reportCessna U206F · Holoyoke, MAWhile en route at 6000 ft, the acft lost power. The plt descended through a scattered layer of clouds and made a forced landing in a grass covered field 1 1/2 miles north of barnes municipal airport, shearing off the nose gear and coming to rest inverted.…Sep 11, 1986 · N8316Q · Substantial damage NTSB NYC85LA011Accident · No injuriesLimited investigationFinal reportCessna 206 · Menemsha, MADuring climb out when the plt normally retracted the landing gear he was copying an IFR clearance. The gear were not retracted and upon touchdown in the pond the float acft nosed over in the 8 ft deep water.Oct 20, 1984 · N8063E · Substantial damage NTSB NYC77DNA18Accident · No injuriesClosedCessna 206 · Boston, MAJun 3, 1977 · N4656Q · Substantial damage NTSB NYC75DNA24Accident · No injuriesClosedCessna 210J · Marlborough, MAMay 23, 1975 · N3328S · Substantial damage NTSB NYC75FNA02Accident · No injuriesClosedCessna U206B · Newburyport, MAJul 4, 1974 · N3893G · Substantial damage NTSB NYC74DNA35Accident · No injuriesClosedCessna 206 · Nantucket, MAFeb 23, 1974 · N70594 · Substantial damage NTSB NYC74DNA27Accident · No injuriesClosedBeech 35C33A · Hyannis, MANov 22, 1973 · N7978M · Substantial damage NTSB NYC74FNA16Accident · No injuriesClosedCessna 206 · East Boston, MASep 9, 1973 · N50463 · Substantial damage NTSB NYC72FNE11Accident · Minor injuriesClosedBeech 35C33A · Deerfield, MAAug 12, 1971 · N1866C · Substantial damage NTSB NYC72AN018Accident · No injuriesClosedCessna 402 · New Bedford, MAAug 2, 1971 · N8125F · Substantial damage NTSB NYC71IN014Incident · No injuriesClosedCessna 402 · New Bedford, MAJul 31, 1970 · N8125F · Minor damage NTSB NYC67F0565Accident · No injuriesClosedCessna 210D · North Adams, MAMar 19, 1967 · N3801Y · Substantial damage NTSB NYC67F0436Accident · No injuriesClosedCessna 210 · Newburyport, MADec 17, 1966 · N3940Y · Substantial damage