Skip to content

NTSB investigations: Continental I0-470 series, NJ

29 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" = 'NJ' 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\" = 'NJ' 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" = 'NJ' 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 ERA21LA312Accident · No injuriesClass 4 · LimitedFinal reportBeech K35 · Readington, NJThe failure of the forward end of the landing gear actuator rod.Jul 30, 2021 · N44DB · Substantial damage NTSB GAA19CA427Accident · No injuriesData collectionFinal reportBeech 35 · Caldwell, NJThe pilot's distraction while looking for traffic, which led to his failure to extend the landing gear before landing, and his exceedance of the airplane's critical angle of attack during a subsequent go-around, which resulted in an aerodynamic stall.Jun 26, 2019 · N1361Z · Substantial damage NTSB ERA16LA271Accident · No injuriesLimited investigationFinal reportCessna 310L · Linden, NJThe overtravel of the main landing gear (MLG) actuator, which resulted in the MLG partially collapsing upon landing. The reasons for the overtravel of the MLG actuator could not be determined due to the unavailability of the wreckage.Jul 23, 2016 · N3261X · Substantial damage NTSB ERA15LA071Accident · Minor injuriesLimited investigationFinal reportCessna 210 5(205) · Sussex, NJMaintenance personnel’s inadequate inspection of the No. 2 cylinder valve area during the most recent annual inspection, which resulted in the in-flight failure of the intake valve springs due to rust on the spring surfaces and subsequent fatigue cracking.Dec 4, 2014 · N8296Z · Substantial damage NTSB NYC99LA182Accident · Serious injuriesLimited investigationFinal reportCessna 210 · Newton, NJThe pilot's failure to secure the oil cap after adding oil; the flight instructor's failure to insure the preflight was completed properly; and oil on the windshield obstructing forward vision.Jul 23, 1999 · N9712X · Substantial damage NTSB NYC90LA028Accident · No injuriesLimited investigationFinal reportCessna 205 · Morristown, NJIn-flight collision with object.Nov 12, 1989 · N8419Z · Substantial damage NTSB NYC83LA255Accident · No injuriesLimited investigationFinal reportBeech B55 · Pomona, NJDuring the landing roll the plt applied brakes and the left main landing gear collpased. The acft turned to the left and the remaining gear collapsed. The acft veered off the side of the rwy, dug into the soft dirt and spun around.Sep 22, 1983 · N4148W · Substantial damage NTSB NYC83FA054Accident · 4 fatalField investigationFinal reportCessna 310R · Atlantic City, NJThe flt proceeded routinely from chicago to Atlantic City. Communications and procedures all seemed routine and normal and at 1901 local control at Atlantic City informed the pilot that he was one mile out and should be picking up the 'rabbit' momentarily. At…Jan 29, 1983 · N310TA · Destroyed NTSB NYC81FHD14Accident · Minor injuriesClosedBeech 35-B33 · Camden, NJFeb 28, 1981 · N9691Y · Destroyed NTSB NYC80FHA11Accident · No injuriesClosedBeech M35 · Somerville, NJMay 1, 1980 · N9792R · Substantial damage NTSB NYC77FHM05Accident · No injuriesClosedCessna 210 · Flanders, NJNov 20, 1976 · N210TM · Substantial damage NTSB NYC74FHM07Accident · Minor injuriesClosedCessna 310F · Neptune, NJSep 9, 1973 · N5809X · Substantial damage NTSB NYC73FHM11Accident · No injuriesClosedBellanca 260 · Sea Bright, NJSep 5, 1972 · N8812R · Substantial damage NTSB NYC72FHD34Accident · No injuriesClosedCessna 310C · Medford, NJMar 9, 1972 · N6688B · Substantial damage NTSB NYC71DHD09Accident · Minor injuriesClosedCessna 205 · Ocean City, NJJul 24, 1970 · N1883Z · Destroyed NTSB NYC70FHD34Accident · No injuriesClosedBeech K35 · Salem, NJJun 7, 1970 · N826R · Substantial damage NTSB NYC70F0117Accident · No injuriesClosedCessna 310D · Atlantic City, NJJul 30, 1969 · N6740T · Substantial damage NTSB NYC69D0266Accident · No injuriesClosedBeech 35-C33 · Burlington, NJNov 2, 1968 · N5861S · Substantial damage NTSB NYC69D0163Accident · No injuriesClosedCessna 210 · Basking Ridge, NJSep 18, 1968 · N9519X · Substantial damage NTSB NYC69D0111Accident · No injuriesClosedBeech 35-B33 · Moorestown, NJJul 20, 1968 · N795AA · Substantial damage NTSB NYC68D0406Accident · No injuriesClosedCessna 210 · Manville, NJMar 30, 1968 · N9591T · Substantial damage NTSB NYC67D0525Accident · No injuriesClosedCessna 310C · Medford, NJFeb 11, 1967 · N6688B · Substantial damage NTSB NYC67F0287Accident · No injuriesClosedCessna 310 · Morristown, NJOct 4, 1966 · N366J · Substantial damage NTSB NYC67F0266Accident · No injuriesClosedBeech 95-55 · Newark, NJSep 23, 1966 · N1010X · Substantial damage NTSB NYC67F0156Accident · No injuriesClosedCessna 210 · Morristown, NJJul 27, 1966 · N7302E · Substantial damage NTSB NYC66F0504Accident · No injuriesClosedCessna 310D · Bridgeport, NJFeb 12, 1966 · N6876T · Substantial damage NTSB NYC65D0168Accident · No injuriesClosedNardi FN333 · Secaucus, NJApr 17, 1965 · N632 · Substantial damage NTSB UNK64X3264Accident · No injuriesClosedCessna 210 · Andover, NJAug 8, 1964 · N7437E · Substantial damage NTSB UNK64X0716Accident · No injuriesClosedBellanca 14193A · S Plainfield, NJFeb 27, 1964 · N8812R · Substantial damage