NTSB investigations: Continental C90 series, NJ
16 cases on aircraft whose registry engine model is Continental C90 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.
Cases per year
| 1965 | 2 |
|---|---|
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 2 |
| 1971 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1985 | 1 |
| 1993 | 1 |
| 1998 | 1 |
| 2002 | 2 |
| 2004 | 1 |
| 2018 | 1 |
Where
Open the mapLatest cases
Query with SQL
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 ('17009'))
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 ('17009'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 GAA18CA472Accident · Minor injuriesData collectionFinal reportCessna 140 · Mount Holly, NJThe pilot's improper landing flare, which resulted in the airplane ballooning upon landing, and his subsequent loss of directional control and excessive brake application.NTSB NYC04CA159Accident · No injuriesData collectionFinal reportLuscombe 8F · Andover, NJThe pilot's failure to maintain aircraft control during approach. A factor was windshear.NTSB NYC03FA021Accident · 2 fatalField investigationFinal reportMooney M10 · Fairfield, NJThe inadequate visual lookout of both pilots. Factors in the accident were the FAA controller's failure to provide a traffic advisory, the improper decision among the three controllers to leave only one controller in the cab, and night conditions.NTSB NYC02LA181Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Belmar, NJThe improper use of an fuel additive which resulted in a power loss. A factor was the lack of suitable terrain.NTSB NYC98LA084Accident · No injuriesLimited investigationFinal reportCessna 140 · Linden, NJThe pilot in commands improper recovery from a bounced landing.NTSB NYC94LA012Accident · Minor injuriesLimited investigationFinal reportLuscombe T8F · Vernon, NJThe pilot's inadequate preflight inspection, which failed to detect an unsecured dipstick, resulting in oil starvation and the loss of engine power.NTSB NYC85LA089Accident · No injuriesLimited investigationFinal reportErcoupe 415-D · Sussex, NJThe acft experienced a loss of eng pwr during climb shortly after takeoff and was substantially damaged during the forced landing which resulted. The plt reported the eng coughed and lost pwr, however, when the throttle was pumped, pwr returned. Pwr was then…NTSB NYC76FHD16Accident · No injuriesClosedAlon A-2 · Ocean City, NJNTSB NYC75AN109Accident · 2 fatalClosedAlon A-2 · Vineland, NJNTSB NYC72FHD24Accident · Minor injuriesClosedChampion 7FC · Moorestown, NJNTSB NYC69D0260Accident · No injuriesClosedLuscombe 8F · Pluckimen, NJNTSB NYC68F0449Accident · Minor injuriesClosedChampion 7EC · So.Plainfield, NJNTSB NYC68D0223Accident · Serious injuriesClosedCessna 140A · Atlantic City, NJNTSB NYC67D0099Accident · No injuriesClosedLuscombe 8F · Lincoln Park, NJNTSB NYC65D0221Accident · No injuriesClosedChampion 7FC · Lumberton, NJNTSB NYC65F0143Accident · No injuriesClosedCessna 195 · Millville, NJ