Skip to content

NTSB investigations: Continental 0-300 series

3,125 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, 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."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.\"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."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 FTW66F0460Accident · Serious injuriesClosedCessna 172A · College Sta, TXDec 19, 1965 · N7190T · Substantial damage NTSB NYC66F0398Accident · No injuriesClosedCessna 172 · Gaithersburg, MDDec 11, 1965 · N6836X · Substantial damage NTSB DEN66A0046Accident · 1 fatalClosedCessna 172 · Kremmling, CODec 11, 1965 · N1469Y · Destroyed NTSB LAX66A0047Accident · 2 fatalClosedCessna 172 · Winterhaven, CADec 9, 1965 · N8242U · Destroyed NTSB FTW66F0453Accident · No injuriesClosedCessna 172 · Houston, TXDec 9, 1965 · N8935B · Substantial damage NTSB NYC66F0388Accident · Serious injuriesClosedCessna 172 · Stevensville, MDDec 4, 1965 · N2560U · Destroyed NTSB CHI66F0506Accident · No injuriesClosedCessna 172 · Moline, ILDec 3, 1965 · N5766T · Substantial damage NTSB CHI66F0448Accident · No injuriesClosedCessna 172 · Freeland, MIDec 1, 1965 · N8861U · Substantial damage NTSB NYC66A0061Accident · Serious injuriesClosedCessna 172 · Petersburg, WVNov 30, 1965 · N8147U · Minor damage NTSB DEN66D0189Accident · No injuriesClosedCessna 170 · Montrose, CONov 30, 1965 · N3517C · Substantial damage NTSB FTW66F0427Accident · No injuriesClosedCessna 172 · Megargel, TXNov 29, 1965 · N2916U · Substantial damage NTSB LAX66F0273Accident · No injuriesClosedCessna 172 · Santa Susana, CANov 25, 1965 · N5536R · Substantial damage NTSB FTW66D0501Accident · No injuriesClosedCessna 172D · Punta De Mita, MexicoNov 25, 1965 · N2661U · Substantial damage NTSB FTW66D0440Accident · No injuriesClosedCessna 172 · Oklahoma City, OKNov 24, 1965 · N6812X · Substantial damage NTSB OAK66D0162Accident · No injuriesClosedCessna 172D · San Francisco, CANov 17, 1965 · N2693U · Substantial damage NTSB DEN66F0156Accident · No injuriesClosedCessna 172 · Usaf Academy, CONov 14, 1965 · N346TC · Substantial damage NTSB NYC66D0342Accident · No injuriesClosedCessna 172 · College Park, MDNov 13, 1965 · N6225E · Substantial damage NTSB MIA66F0338Accident · No injuriesClosedCessna 172 · Deland, FLNov 12, 1965 · N8625U · Substantial damage NTSB NYC66A0054Accident · No injuriesClosedCessna 172 · Jamaica, NYNov 10, 1965 · N7760U · Substantial damage NTSB CHI66D0431Accident · No injuriesClosedCessna 172 · Canton, OHNov 10, 1965 · N9170B · Substantial damage NTSB SEA66F0164Accident · Minor injuriesClosedCessna 172F · Springfield, ORNov 4, 1965 · N8467U · Substantial damage NTSB FTW66F0421Accident · No injuriesClosedCessna 172 · Corpus Christi, TXNov 2, 1965 · N5646R · Substantial damage NTSB CHI66F0430Accident · No injuriesClosedCessna 172 · Fort Wayne, INNov 1, 1965 · N7227T · 2 aircraft · Substantial damage NTSB MIA66F0309Accident · No injuriesClosedCessna 172F · Homestead, FLOct 30, 1965 · N8748U · Substantial damage NTSB MKC66D0330Accident · Minor injuriesClosedCessna 172 · Waukon, IAOct 29, 1965 · N5491R · Substantial damage NTSB MKC66D0308Accident · No injuriesClosedCessna 172 · Maple Plain, MNOct 29, 1965 · N6345E · Substantial damage NTSB MKC66D0290Accident · No injuriesClosedCessna 172 · Reed Springs, MOOct 23, 1965 · N7286T · Substantial damage NTSB OAK66D0130Accident · No injuriesClosedCessna 172D · Tracy, CAOct 22, 1965 · N2105Y · Substantial damage NTSB FTW66D0404Accident · No injuriesClosedCessna 172 · Mirando City, TXOct 22, 1965 · N3069U · Substantial damage NTSB MIA66F0314Accident · No injuriesClosedCessna 172 · Ludowici, GAOct 21, 1965 · N7367T · Substantial damage NTSB NYC66D0316Accident · No injuriesClosedCessna 170B · Baltimore, MDOct 18, 1965 · N3483D · Substantial damage NTSB NYC66D0321Accident · No injuriesClosedCessna 172 · Pennington Gap, VAOct 17, 1965 · N2741U · Substantial damage NTSB MIA66D0359Accident · No injuriesClosedCessna 172 · Aliceville, ALOct 17, 1965 · N8385B · Substantial damage NTSB NYC66F0312Accident · No injuriesClosedCessna 172 · Tupper Lake, NYOct 15, 1965 · N2456U · Substantial damage NTSB NYC66D0295Accident · No injuriesClosedCessna 172 · Moorestown, NJOct 14, 1965 · N7320T · Substantial damage NTSB MKC66D0257Accident · No injuriesClosedCessna 172 · Warrensburg, MOOct 13, 1965 · N5674R · Substantial damage NTSB CHI66F0353Accident · Minor injuriesClosedMaule M-4 · Columbus, OHOct 13, 1965 · N4615T · Destroyed NTSB NYC66F0311Accident · No injuriesClosedCessna 172 · Farmingdale, NJOct 12, 1965 · N7091T · Substantial damage NTSB FTW66F0385Accident · No injuriesClosedCessna 172 · Tulsa, OKOct 9, 1965 · N5497R · Substantial damage NTSB DEN66F0131Accident · No injuriesClosedCessna 172 · Albin, WYOct 7, 1965 · N8058B · Substantial damage NTSB CHI66F0355Accident · No injuriesClosedCessna 172 · Delaware, OHOct 7, 1965 · N6430E · Substantial damage NTSB NYC66F0244Accident · No injuriesClosedCessna 172 · Harwinton, CTOct 3, 1965 · N7459T · Substantial damage NTSB LAX66F0112Accident · No injuriesClosedCessna 172 · Santa Monica, CAOct 3, 1965 · N8307B · Substantial damage NTSB MIA66D0292Accident · No injuriesClosedCessna 172 · Miami, FLOct 2, 1965 · N3920S · Substantial damage NTSB LAX66D0148Accident · No injuriesClosedCessna 172 · Santa Susana, CAOct 2, 1965 · N5622A · Substantial damage NTSB CHI66F0340Accident · No injuriesClosedCessna 172 · Findlay, OHSep 29, 1965 · N8854U · Substantial damage NTSB NYC66D0360Accident · No injuriesClosedCessna 172 · Erie, PASep 22, 1965 · N5360R · Substantial damage NTSB CHI66F0435Accident · Minor injuriesClosedCessna 172 · Lake Geneva, WISep 22, 1965 · N6287E · Substantial damage NTSB DEN66D0134Accident · No injuriesClosedCessna 170B · Phoenix, AZSep 21, 1965 · N2917D · Substantial damage NTSB FTW66D0322Accident · No injuriesClosedCessna 172 · New Orleans, LASep 19, 1965 · N1803Y · Substantial damage