Skip to content

NTSB investigations: Continental 0-300 series, NJ

38 cases on aircraft whose registry engine model is Continental 0-300 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

NTSB investigations: Continental 0-300 series, NJ per year, 1964–2026: 38 cases
1964	2
1965	4
1966	3
1967	4
1968	1
1969	1
1970	1
1971	3
1972	1
1973	2
1974	1
1975	1
1976	1
1977	1
1979	1
1980	1
1981	1
1990	1
1994	1
2001	1
2003	1
2005	1
2006	1
2010	1
2019	1
2021	1

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 ('17022')) 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 ('17022'))
  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 ('17022'))
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 ERA22LA102Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Berlin, NJAn inadvertent in-flight collision with a goose while on approach.Dec 29, 2021 · N6295E · Substantial damage NTSB ERA20LA034Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Toms River, NJThe failure of the Cessna 172N pilot to see and avoid a second airplane while maneuvering in the traffic pattern, which resulted in a midair collision. Contributing to the accident was the failure of the Cessna 172N pilot to tune his radio to the correct…Nov 13, 2019 · N3958S · 2 aircraft · Substantial damage NTSB ERA10FA202Accident · 1 fatalField investigationFinal reportCessna 172E · West Milford, NJThe complete loss of engine power due to fuel starvation.Apr 3, 2010 · N5528T · Substantial damage NTSB NYC06CA107Accident · No injuriesData collectionFinal reportCessna 172D · Lumberton, NJThe student pilot's failure to maintain aircraft control while landing, which resulted in an runway overrun and subsequent impact with terrain.May 2, 2006 · N2549Y · Substantial damage NTSB NYC06FA025Accident · 1 fatalField investigationFinal reportCessna 172A · Pohatcong, NJThe inadequate visual lookout of the pilots in both airplanes, which resulted in a midair collision during descent.Nov 5, 2005 · N7467T · 2 aircraft · Substantial damage NTSB NYC03LA112Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Ocean City, NJThe pilot's failure to maintain directional control during an aborted landing. A factor was a crosswind.May 20, 2003 · N3985L · Substantial damage NTSB NYC01LA227Accident · No injuriesLimited investigationFinal reportCessna 170B · Wildwood, NJthe pilot's inadequate compensation for wind conditions. Factors were the crosswind and the gusts.Sep 28, 2001 · N3465D · Substantial damage NTSB NYC94LA112Accident · No injuriesLimited investigationFinal reportCessna 172 · Tinton Falls, NJThe loss of engine power for undetermined reasons.Jul 1, 1994 · N6979X · Substantial damage NTSB NYC90LA079Accident · No injuriesLimited investigationFinal reportCessna 172H · Andover, NJThe pilot failed to maintain control of the aircraft after encounter with turbulence during landing.Mar 18, 1990 · N8213L · Substantial damage NTSB NYC81FA067Accident · Minor injuriesClosedCessna 172 · Bridgeport, NJJun 25, 1981 · N8852B · Substantial damage NTSB NYC80FA043Accident · 3 fatalClosedCessna 172G · Cape May, NJJun 2, 1980 · N3847L · Destroyed NTSB NYC79FHM18Accident · No injuriesClosedCessna 172 · Matawan, NJMay 17, 1979 · N10622 · Substantial damage NTSB NYC77FHA24Accident · No injuriesClosedCessna 172B · Vernon, NJJul 3, 1977 · N6967X · Substantial damage NTSB NYC76FHA32Accident · No injuriesClosedCessna 170A · Pittstown, NJApr 11, 1976 · N7A · Substantial damage NTSB NYC75FHD32Accident · Minor injuriesClosedCessna 172 · Atlantic City, NJMar 6, 1975 · N7953U · Substantial damage NTSB NYC75DHA28Accident · No injuriesClosedCessna 170A · Pittstown, NJDec 28, 1974 · N7A · Substantial damage NTSB NYC74DHD07Accident · No injuriesClosedCessna 172H · Vineland, NJAug 6, 1973 · N2468L · Substantial damage NTSB NYC73FHA24Accident · No injuriesClosedCessna 172 · Basking Ridge, NJApr 17, 1973 · N3636S · Substantial damage NTSB NYC72FHM35Accident · No injuriesClosedCessna 172E · Farmingdale, NJMar 8, 1972 · N5414T · Substantial damage NTSB NYC72FHD02Accident · No injuriesClosedCessna 172 · Atlantic City, NJJul 10, 1971 · N8243B · Substantial damage NTSB NYC71FHA49Accident · No injuriesClosedCessna 172 · Clinton, NJMay 19, 1971 · N2566Y · Substantial damage NTSB NYC71DHD39Incident · Minor injuriesClosedCessna 172 · Riverdale, NJFeb 16, 1971 · N5511R · Minor damage NTSB NYC71FHA09Accident · Minor injuriesClosedCessna 172 · Hamburg, NJJul 29, 1970 · N5489T · Destroyed NTSB NYC70F0223Accident · No injuriesClosedCessna 172 · Newton, NJDec 7, 1969 · N6156E · Substantial damage NTSB NYC68F0484Accident · Minor injuriesClosedCessna 182 · Medford, NJMay 31, 1968 · N8761U · Substantial damage NTSB NYC68D0204Accident · No injuriesClosedCessna 172H · Mays Landing, NJSep 20, 1967 · N3281L · Substantial damage NTSB NYC68D0114Accident · No injuriesClosedCessna 172 · Andover, NJAug 28, 1967 · N3251L · Substantial damage NTSB NYC68F0020Accident · No injuriesClosedCessna 172F · East Hanover, NJJun 11, 1967 · N8808U · Substantial damage NTSB NYC67F0426Accident · No injuriesClosedCessna 172 · Readington, NJJan 2, 1967 · N441TS · Substantial damage NTSB NYC67D0494Accident · No injuriesClosedCessna 172 · Moorestown, NJDec 30, 1966 · N5563T · Substantial damage NTSB NYC67F0239Accident · No injuriesClosedCessna 172 · Neptune, NJAug 18, 1966 · N5414T · Substantial damage NTSB NYC66F0635Accident · No injuriesClosedMaule M-4 · Sussex, NJApr 25, 1966 · N9827M · Substantial damage NTSB NYC66D0295Accident · No injuriesClosedCessna 172 · Moorestown, NJOct 14, 1965 · N7320T · Substantial damage NTSB NYC66F0311Accident · No injuriesClosedCessna 172 · Farmingdale, NJOct 12, 1965 · N7091T · Substantial damage NTSB NYC66F0086Accident · No injuriesClosedCessna 172 · Basking Ridge, NJJul 27, 1965 · N2654U · Substantial damage NTSB NYC65D0175Accident · No injuriesClosedCessna 172 · Blackwood, NJApr 10, 1965 · N6049A · Substantial damage NTSB UNK65X1018Accident · No injuriesClosedCessna 172 · Teterboro, NJDec 15, 1964 · N5413T · Substantial damage NTSB UNK65X0865Accident · No injuriesClosedCessna 172 · Blackwood, NJNov 28, 1964 · N6049A · Substantial damage