Skip to content

NTSB investigations: Continental 0-200 series, MA

98 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

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" = 'MA' 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

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\" = 'MA' 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" = 'MA' 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

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 NYC76DNA35Accident · No injuriesClosedCessna 150 · Norfolk, MAApr 20, 1976 · N63439 · Substantial damage NTSB NYC76FNE19Accident · No injuriesClosedCessna 150 · Worcester, MAMar 25, 1976 · N8353J · Substantial damage NTSB NYC76FNA09Accident · No injuriesClosedCessna 150 · Norwood, MAAug 9, 1975 · N7949F · Substantial damage NTSB NYC75DNE16Accident · No injuriesClosedCessna 150 · Westboro, MAOct 15, 1974 · N7063S · Substantial damage NTSB NYC75FNE06Accident · No injuriesClosedCessna 150G · Washington, MAAug 14, 1974 · N3427J · Substantial damage NTSB NYC75DNA04Accident · Minor injuriesClosedCessna 150L · Stow, MAJul 13, 1974 · N11386 · Substantial damage NTSB NYC74FNA28Accident · No injuriesClosedCessna 150L · Lawrence, MADec 2, 1973 · N7529G · Substantial damage NTSB NYC74DNE06Accident · No injuriesClosedCessna 150 · Orange, MASep 16, 1973 · N18637 · Substantial damage NTSB NYC74FNE02Accident · No injuriesClosedCessna 150F · Wendell, MAAug 13, 1973 · N8860G · Substantial damage NTSB NYC73FNE33Accident · No injuriesClosedCessna 150L · Northamton, MAMay 13, 1973 · N18678 · Substantial damage NTSB NYC73DNA40Accident · No injuriesClosedCessna 150 · Hyannis, MAFeb 23, 1973 · N6209G · Substantial damage NTSB NYC73FNA31Accident · Minor injuriesClosedCessna 150K · Middleboro, MANov 19, 1972 · N6294G · Substantial damage NTSB NYC73FNA22Accident · No injuriesClosedCessna 150 · Bedford, MAOct 4, 1972 · N6346G · Substantial damage NTSB NYC73DNA13Accident · No injuriesClosedCessna 150J · Middleboro, MAAug 17, 1972 · N60248 · Substantial damage NTSB NYC73FNA08Accident · No injuriesClosedCessna 150 · Norwood, MAJul 30, 1972 · N5907G · Substantial damage NTSB NYC73FNA07Accident · No injuriesClosedCessna 150L · Chatham, MAJul 24, 1972 · N16007 · Substantial damage NTSB NYC73DNA05Accident · No injuriesClosedCessna 150J · Groton, MAJul 2, 1972 · N5549G · Substantial damage NTSB NYC72FNE21Accident · No injuriesClosedCessna 150 · Turnrs Falls, MAJan 1, 1972 · N100FA · Substantial damage NTSB NYC72FNE18Accident · Serious injuriesClosedCessna 150J · Goshen, MADec 12, 1971 · N61180 · Substantial damage NTSB NYC72AN052Accident · No injuriesClosedPiper PA-32 · Fitchburg, MASep 9, 1971 · N294HA · 2 aircraft · Minor damage NTSB NYC71DFD43Accident · No injuriesClosedCessna 150 · N Middleboro, MAMar 10, 1971 · N4679X · Substantial damage NTSB NYC71DFD34Accident · No injuriesClosedCessna 150 · Fall River, MAJan 23, 1971 · N3122J · Substantial damage NTSB NYC71DFD31Accident · No injuriesClosedCessna 150 · Franklin, MAJan 13, 1971 · N60460 · Substantial damage NTSB NYC71FFD32Accident · No injuriesClosedCessna 150K · Marlboro, MAJan 9, 1971 · N6346G · Substantial damage NTSB NYC71DFD13Accident · Minor injuriesClosedCessna 150E · Hingham, MASep 26, 1970 · N6120T · Substantial damage NTSB NYC70DFD05Accident · No injuriesClosedCessna 150 · Marshfield, MAJan 16, 1970 · N6286S · Substantial damage NTSB NYC70DFD03Accident · No injuriesClosedCessna 150 · Marshfield, MAJan 8, 1970 · N6618S · Substantial damage NTSB NYC70D0028Accident · No injuriesClosedCessna 150 · Westboro, MAJun 14, 1969 · N3208X · Substantial damage NTSB NYC69D0448Accident · No injuriesClosedCessna 150 · Newburyport, MAMay 18, 1969 · N6730F · Substantial damage NTSB NYC69D0366Accident · No injuriesClosedCessna 150 · Palmer, MAMar 10, 1969 · N5927E · Substantial damage NTSB NYC69D0122Accident · No injuriesClosedCessna 150 · Ipswich, MAJul 30, 1968 · N8353J · Substantial damage NTSB NYC68F0277Accident · No injuriesClosedCessna 150 · Bedford, MAOct 25, 1967 · N6588F · Substantial damage NTSB NYC68D0199Accident · No injuriesClosedCessna 150 · Monterey, MASep 21, 1967 · N8035S · Substantial damage NTSB NYC68D0106Accident · No injuriesClosedCessna 150 · Sterling Jct, MAAug 12, 1967 · N3063X · Substantial damage NTSB NYC68D0060Accident · No injuriesClosedCessna 150 · Shirley, MAJul 11, 1967 · N3099X · Destroyed NTSB NYC67D0625Accident · No injuriesClosedCessna 150 · Plymouth, MAMar 21, 1967 · N2454J · Substantial damage NTSB NYC67D0455Accident · No injuriesClosedCessna 150 · Sheffield, MADec 30, 1966 · N8663G · Substantial damage NTSB NYC67D0425Accident · No injuriesClosedCessna 150 · Norwood, MADec 18, 1966 · N3078X · Substantial damage NTSB NYC67F0318Accident · No injuriesClosedCessna 150F · Greenfield, MAOct 9, 1966 · N6834F · Substantial damage NTSB NYC66F0636Accident · No injuriesClosedCessna 150 · Bedford, MAApr 17, 1966 · N8171S · Substantial damage NTSB NYC66F0644Accident · No injuriesClosedCessna 150 · Bedford, MAFeb 22, 1966 · N8366G · Substantial damage NTSB NYC66D0358Accident · No injuriesClosedCessna 150 · Falmouth, MANov 21, 1965 · N7728E · Substantial damage NTSB NYC66F0267Accident · No injuriesClosedCessna 150 · Beverly, MASep 22, 1965 · N7884E · Substantial damage NTSB NYC66F0038Accident · No injuriesClosedCessna 150 · Tewksbury, MAMay 8, 1965 · N3963U · Substantial damage NTSB NYC65F0093Accident · No injuriesClosedCessna 150 · Ware, MAMar 16, 1965 · N4209U · Substantial damage NTSB UNK65X0221Accident · No injuriesClosedCessna 150 · Hanson, MAOct 10, 1964 · N7728E · Substantial damage NTSB UNK64X4021Accident · No injuriesClosedCessna 172A · Beverly, MASep 17, 1964 · N9712T · Minor damage NTSB UNK64X1883Accident · No injuriesClosedCessna 150 · Northhampton, MAMay 22, 1964 · N6492T · Substantial damage