NTSB investigations: Continental 0-200 series, NJ
126 cases on aircraft whose registry engine model is Continental 0-200 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, newest first
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 ('17020'))
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 ('17020'))
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 NYC77FHD03Accident · No injuriesClosedCessna 150M · Waterford, NJNTSB NYC76FHM16Accident · No injuriesClosedCessna 150 · Wayne Township, NJNTSB NYC76FHM14Accident · Minor injuriesClosedCessna 150H · Lincoln Park, NJNTSB NYC76FHA09Accident · No injuriesClosedCessna 150 · Blairstown, NJNTSB NYC76AN018Accident · No injuriesClosedCessna 150 · Readington, NJNTSB NYC75AN123Accident · No injuriesClosedCessna 150 · Teterboro, NJNTSB NYC75FHA33Accident · No injuriesClosedCessna 150 · Blairstown, NJNTSB NYC75DHA30Accident · No injuriesClosedCessna 150 · Blairstown, NJNTSB NYC75DHA21Accident · No injuriesClosedCessna 150 · Readington, NJNTSB NYC75DHM01Accident · Serious injuriesClosedCessna 150 · Flanders, NJNTSB NYC74DHA32Accident · No injuriesClosedCessna 150 · Pattenburg, NJNTSB NYC74DHA31Accident · Minor injuriesClosedCessna 150 · Somerville, NJNTSB NYC74DHA27Accident · No injuriesClosedCessna 150G · Pittstown, NJNTSB NYC74DHA26Accident · No injuriesClosedCessna 150J · Stillwater, NJNTSB NYC74FHM23Accident · No injuriesClosedCessna 150 · Teterboro, NJNTSB NYC74DHD19Accident · No injuriesClosedCessna 150 · Hammonton, NJNTSB NYC74FHA02Accident · No injuriesClosedCessna 150 · Sussex, NJNTSB NYC73DHD36Accident · No injuriesClosedCessna 150 · Williamstown, NJNTSB NYC73FHD26Accident · No injuriesClosedCessna 150L · Williamstown, NJNTSB NYC73DHD15Accident · No injuriesClosedCessna 150 · Hammaton, NJNTSB NYC73FHA10Accident · No injuriesClosedCessna 150K · Manville, NJNTSB NYC73FHD03Accident · No injuriesClosedCessna 150L · Ocean City, NJNTSB NYC72FHM33Accident · Minor injuriesClosedCessna 150 · Morristown, NJNTSB NYC72DHA19Accident · No injuriesClosedCessna 150 · Manville, NJNTSB NYC72DHD06Accident · No injuriesClosedCessna 150 · Wildwood, NJNTSB NYC71DHD51Accident · No injuriesClosedCessna 150 · Atlantic City, NJNTSB NYC71DHD44Accident · No injuriesClosedCessna 150 · Rio Grande, NJNTSB NYC71DHA29Accident · No injuriesClosedCessna 150 · Manville, NJNTSB NYC71AN055Accident · 1 fatalClosedCessna 150H · Mountain Lakes, NJNTSB NYC71DHD05Accident · No injuriesClosedCessna 150 · Moorestown, NJNTSB NYC70DHD22Accident · No injuriesClosedCessna 150 · Wildwood, NJNTSB NYC70DHD21Accident · No injuriesClosedCessna 150 · Medford, NJNTSB NYC70DHA09Accident · No injuriesClosedCessna 150 · Sussex, NJNTSB NYC70DHA08Accident · No injuriesClosedCessna 150 · Somerville, NJNTSB NYC70D0229Accident · No injuriesClosedCessna 150 · Lakewood, NJNTSB NYC70D0014Accident · No injuriesClosedCessna 150 · Williamstown, NJNTSB NYC69D0374Accident · No injuriesClosedCessna 150 · Flemington, NJNTSB NYC69D0370Accident · No injuriesClosedCessna 150 · Whitehouse, NJNTSB NYC69F0210Accident · Serious injuriesClosedCessna 150J · Morristown, NJNTSB NYC69F0048Accident · No injuriesClosedCessna 150F · Medford, NJNTSB NYC69D0013Accident · Minor injuriesClosedCessna 150F · Lumberton, NJNTSB NYC68D0478Accident · No injuriesClosedCessna 150 · Montville Twp, NJNTSB NYC68F0372Accident · Minor injuriesClosedCessna 150 · Hanover, NJNTSB NYC68F0269Accident · No injuriesClosedCessna 150 · Teterboro, NJNTSB NYC68F0233Accident · No injuriesClosedCessna 150 · Totowa, NJNTSB NYC68F0096Accident · No injuriesClosedCessna 150 · Medford, NJNTSB NYC68F0032Accident · No injuriesClosedCessna 150 · Pittstown, NJNTSB NYC67D0661Accident · No injuriesClosedCessna 150 · Colts Neck, NJNTSB NYC67D0699Accident · No injuriesClosedCessna 150 · Sewell, NJNTSB NYC67D0614Accident · No injuriesClosedCessna 150 · Totowa, NJ