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 SEA66D0272Accident · No injuriesClosedCessna 172 · Heppner, ORMay 12, 1966 · N8141X · Substantial damage NTSB DEN67D0013Accident · No injuriesClosedCessna 172 · Sierra Vista, AZMay 11, 1966 · N9180Z · Substantial damage NTSB MIA66D0533Accident · No injuriesClosedCessna 170B · Raymond, MSMay 8, 1966 · N3482C · Substantial damage NTSB FTW66F0664Accident · No injuriesClosedCessna 172 · Newellton, LAMay 8, 1966 · N6941X · Substantial damage NTSB DEN66D0338Accident · No injuriesClosedCessna 170B · Phoenix, AZMay 8, 1966 · N8194A · Substantial damage NTSB CHI66F0720Accident · No injuriesClosedCessna 172 · Dimondale, MIMay 7, 1966 · N6428B · Substantial damage NTSB MIA66F0519Accident · Minor injuriesClosedCessna 172 · Clemmons, NCMay 5, 1966 · N2815U · Substantial damage NTSB MIA66A0128Accident · 2 fatalClosedCessna 172E · Clearwater, FLMay 5, 1966 · N3907S · Destroyed NTSB CHI66D0754Accident · Minor injuriesClosedCessna 152 · Leveland, OHMay 5, 1966 · N3609L · Substantial damage NTSB MKC66F0537Accident · No injuriesClosedMaule M-4 · Fredericktown, MOMay 2, 1966 · N4715T · Substantial damage NTSB CHI66D0722Accident · No injuriesClosedCessna 172 · Leonidas, MIMay 2, 1966 · N8363B · Substantial damage NTSB OAK66F0287Accident · No injuriesClosedGlobe GC-1B · Novato, CAMay 1, 1966 · N80969 · Substantial damage NTSB MKC66F0548Accident · Serious injuriesClosedCessna 172 · St Donatus, IAApr 29, 1966 · N4103L · Substantial damage NTSB CHI66D0746Accident · No injuriesClosedCessna 172 · Angola, INApr 29, 1966 · N5999A · Substantial damage NTSB NYC66F0635Accident · No injuriesClosedMaule M-4 · Sussex, NJApr 25, 1966 · N9827M · Substantial damage NTSB CHI66F0734Accident · No injuriesClosedCessna 172 · Kendallville, INApr 20, 1966 · N1362Y · Substantial damage NTSB MKC66F0563Accident · Minor injuriesClosedCessna 172 · Neodesha, KSApr 17, 1966 · N5638R · Substantial damage NTSB LAX66D0340Accident · No injuriesClosedCessna 172 · Adelanto, CAApr 17, 1966 · N5647T · Substantial damage NTSB NYC66D0592Accident · No injuriesClosedCessna 172 · Reading, PAApr 16, 1966 · N8691U · Substantial damage NTSB CHI66F0705Accident · No injuriesClosedCessna 172 · Bronson, MIApr 14, 1966 · N8368X · Substantial damage NTSB SEA66F0240Accident · Minor injuriesClosedCessna 172 · Pullman, WAApr 13, 1966 · N7721T · Substantial damage NTSB MKC66F0506Accident · No injuriesClosedCessna 172 · Lincoln, NEApr 13, 1966 · N2843U · Substantial damage NTSB ANC66D0094Accident · No injuriesClosedMaule M-4 · Fairbanks, AKApr 11, 1966 · N12023 · Substantial damage NTSB CHI66F0685Accident · No injuriesClosedCessna 172E · Beaver Dam, WIApr 10, 1966 · N5361T · Substantial damage NTSB FTW66D0689Accident · No injuriesClosedCessna 172 · Prto Lobos, MexicoApr 8, 1966 · N8305U · Substantial damage NTSB FTW66D0623Accident · No injuriesClosedCessna 172 · Freemason Is, LAApr 8, 1966 · N7967B · Substantial damage NTSB DEN66F0273Accident · Minor injuriesClosedCessna 172 · Pueblo, COApr 6, 1966 · N3919L · Substantial damage NTSB MIA66F0487Accident · No injuriesClosedCessna 172 · Tchula, MSApr 5, 1966 · N5483R · Substantial damage NTSB DEN66F0272Accident · No injuriesClosedCessna 172 · Greely, COApr 5, 1966 · N4264L · Substantial damage NTSB CHI66D0696Accident · No injuriesClosedCessna 172 · New London, OHApr 3, 1966 · N5489R · Substantial damage NTSB MKC66F0528Accident · No injuriesClosedCessna 172 · St. Joseph, MOApr 2, 1966 · N5755R · Substantial damage NTSB MKC66F0508Accident · Serious injuriesClosedCessna 172D · Kearney, NEApr 2, 1966 · N2407Y · Substantial damage NTSB MKC66D0523Accident · No injuriesClosedCessna 172 · Wichita, KSApr 2, 1966 · N4225L · Destroyed NTSB MKC66D0490Accident · No injuriesClosedCessna 172 · Moberly, MOApr 2, 1966 · N5652T · Substantial damage NTSB MIA66D0485Accident · No injuriesClosedCessna 172 · Muscle Shoals, ALApr 2, 1966 · N7426X · Substantial damage NTSB MKC66D0532Accident · No injuriesClosedCessna 172 · Faribault, MNMar 31, 1966 · N8264B · Substantial damage NTSB MKC66D0527Accident · No injuriesClosedCessna 172 · Creston, IAMar 31, 1966 · N3940S · Substantial damage NTSB MKC66D0524Accident · No injuriesClosedCessna 172 · Yankton, SDMar 31, 1966 · N5600A · Substantial damage NTSB MIA66D0514Accident · No injuriesClosedCessna 172 · Chamblee, GAMar 31, 1966 · N2526U · Substantial damage NTSB MIA66D0503Accident · No injuriesClosedCessna 172 · Dalton, GAMar 31, 1966 · N3792S · Substantial damage NTSB NYC66F0593Accident · Minor injuriesClosedCessna 172F · Haverhill, MAMar 30, 1966 · N8556U · Substantial damage NTSB CHI66D0654Accident · Minor injuriesClosedCessna 172A · W Carrollton, OHMar 30, 1966 · N7746T · Substantial damage NTSB MIA66D0510Accident · No injuriesClosedCessna 172 · Moncks Corner, SCMar 27, 1966 · N5340T · Substantial damage NTSB FTW66F0585Accident · Minor injuriesClosedCessna 172C · Lowake, TXMar 27, 1966 · N1817Y · Substantial damage NTSB MKC67D0001Accident · Minor injuriesClosedCessna 172F · Rich Fountain, MOMar 26, 1966 · N8703U · Substantial damage NTSB FTW66D0583Accident · Minor injuriesClosedCessna 172 · Randlett, OKMar 26, 1966 · N3773S · Substantial damage NTSB MIA66D0473Accident · No injuriesClosedCessna 172 · Ft Lauderdale, FLMar 25, 1966 · N8625U · Substantial damage NTSB DEN66F0265Accident · No injuriesClosedCessna 172 · Kearns, UTMar 24, 1966 · N8307B · Substantial damage NTSB NYC66F0598Accident · No injuriesClosedCessna 170B · Friendly, MDMar 20, 1966 · N2754C · Substantial damage NTSB NYC66F0565Accident · No injuriesClosedCessna 172G · Coraopolis, PAMar 19, 1966 · N3837L · Substantial damage