Skip to content

NTSB investigations: Continental C85 series, NJ

30 cases on aircraft whose registry engine model is Continental C85 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 ('17008')) 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 ('17008'))
  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 ('17008'))
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 NYC07LA192Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Frenchtown, NJA partial loss of engine power for undetermined reasons.Aug 12, 2007 · N6429H · Substantial damage NTSB IAD99LA017Accident · No injuriesLimited investigationFinal reportLuscombe LL-8-C · Caldwell, NJThe pilot-in-command's failure to maintain directional control resulting in a ground-loop.Nov 5, 1998 · N2619K · Substantial damage NTSB BFO95LA040Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Lakewood, NJThe pilot's inadequate compensation for wind conditions and his inadequate evaluation of the weather conditions which resulted in an overrun. A factor is the sudden windshift.Apr 1, 1995 · N85713 · Substantial damage NTSB ATL86FA178Accident · 2 fatalField investigationFinal reportCessna 120 · Marlton, NJAbout 10 min after takeoff, the acft collided with trees & crashed while the plts were performing aerobatic maneuvers. According to witnesses, aerobatics were being performed at an about 500 ft AGL. They rprtd that the plts had made an overhead maneuver…Jun 21, 1986 · N89789 · Destroyed NTSB NYC83LA051Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Sussex, NJAircraft lost power after takeoff at 200 feet and pilot made a turn back towards airport for landing. Engine did not respond to pilots remedial actions. A landing was made in soft grassy terrain on the airport. During landing the right main gear separated and…Jan 8, 1983 · N72280 · Substantial damage NTSB NYC81DHA01Accident · No injuriesClosedAeronca 7DC · Pottstown, NJOct 11, 1980 · N1834E · Substantial damage NTSB NYC76FHM26Accident · No injuriesClosedAeronca S7CCM · Moonachie, NJMay 2, 1976 · N2450E · Substantial damage NTSB NYC75FHD51Accident · No injuriesClosedAeronca 7BCM · Pennington, NJJun 3, 1975 · N9324H · Substantial damage NTSB NYC74FHD18Accident · No injuriesClosedPietenpol Aircam · Lakewood, NJOct 23, 1973 · N5392 · Substantial damage NTSB NYC72DHD41Accident · No injuriesClosedWoodbury Tapsik · Millville, NJJun 4, 1972 · N4506 · Substantial damage NTSB NYC71FHA41Accident · No injuriesClosedErcoupe 415D · Whitehouse, NJMar 27, 1971 · N93969 · Substantial damage NTSB NYC70D0228Accident · No injuriesClosedCessna 120 · Hancocks Brdge, NJDec 11, 1969 · N72147 · Substantial damage NTSB NYC69D0387Accident · No injuriesClosedCessna 140 · Medford, NJMar 8, 1969 · N2507N · Substantial damage NTSB NYC69D0351Accident · No injuriesClosedCessna 120 · Medford, NJFeb 16, 1969 · N77363 · Substantial damage NTSB NYC69A0051Accident · 2 fatalClosedSwift Globe GC-1B · Willingboro, NJNov 3, 1968 · N9030M · Destroyed NTSB NYC69D0214Accident · No injuriesClosedAeronca 7DC · Madison, NJAug 21, 1968 · N85713 · Minor damage NTSB NYC68F0481Accident · 1 fatalClosedErcoupe 415-C · Williamstown, NJApr 28, 1968 · N93331 · Destroyed NTSB NYC68F0268Accident · Serious injuriesClosedCessna 140 · Wayne, NJOct 30, 1967 · N89161 · Destroyed NTSB NYC67D0485Accident · No injuriesClosedCessna 140 · Red Bank, NJJan 2, 1967 · N72427 · Substantial damage NTSB NYC67D0435Accident · No injuriesClosedCessna 120 · Jobstown, NJDec 21, 1966 · N4221N · Substantial damage NTSB NYC67D0327Accident · No injuriesClosedLuscombe 8E · Middletown, NJOct 15, 1966 · N2419K · Substantial damage NTSB NYC67F0168Accident · No injuriesClosedWhitman T-WIND · Sussex, NJAug 14, 1966 · N370Y · Destroyed NTSB NYC66D0535Accident · Minor injuriesClosedPiper J3 · Cherry Hill, NJFeb 7, 1966 · N6384H · Substantial damage NTSB NYC66F0380Accident · No injuriesClosedErcoupe 415-CD · So Plainfield, NJDec 7, 1965 · N2833H · Substantial damage NTSB NYC65D0127Accident · No injuriesClosedCessna 140 · Pitman, NJMar 14, 1965 · N76391 · Substantial damage NTSB NYC65F0025Accident · No injuriesClosedErcoupe 415D · Medford, NJJan 30, 1965 · N3281H · Substantial damage NTSB UNK64X2926Accident · No injuriesClosedErcoure 415C · Hanover, NJJul 19, 1964 · N99288 · Substantial damage NTSB UNK64X1933Accident · No injuriesClosedCessna 140 · W Milford, NJMay 24, 1964 · N1931N · Substantial damage NTSB UNK64X1915Accident · No injuriesClosedErcoupe 415C · Cream Ridge, NJMay 23, 1964 · N94180 · Substantial damage NTSB UNK64X0289Accident · No injuriesClosedCessna 140 · Pittstown, NJJan 19, 1964 · N72195 · Substantial damage