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 UNK65X1055Accident · Minor injuriesClosedCessna 172 · St Nazianz, WIDec 19, 1964 · N4271F · Substantial damage NTSB UNK65X1050Accident · No injuriesClosedCessna 172 · Mesquite, NVDec 19, 1964 · N5503T · Substantial damage NTSB UNK65X1031Accident · No injuriesClosedCessna 172 · Middleburg, VADec 16, 1964 · N7790U · Substantial damage NTSB UNK65X1018Accident · No injuriesClosedCessna 172 · Teterboro, NJDec 15, 1964 · N5413T · Substantial damage NTSB UNK65X0974Accident · No injuriesClosedCessna 172 · Kingman, AZDec 11, 1964 · N1326Y · Substantial damage NTSB UNK65X0947Accident · No injuriesClosedCessna 172 · Riverside, CADec 7, 1964 · N3090U · Substantial damage NTSB UNK65X0912Accident · No injuriesClosedCessna 172 · Westherford, TXDec 4, 1964 · N2360U · Substantial damage NTSB UNK65X0903Accident · No injuriesClosedCessna 172 · Inyokern, CADec 2, 1964 · N7882X · Substantial damage NTSB UNK65X0886Accident · No injuriesClosedCessna 172 · Las Vegas, NVNov 29, 1964 · N8217X · Substantial damage NTSB UNK65X0865Accident · No injuriesClosedCessna 172 · Blackwood, NJNov 28, 1964 · N6049A · Substantial damage NTSB UNK65X0836Accident · No injuriesClosedCessna 170 · Freeman, SDNov 25, 1964 · N3947V · Destroyed NTSB UNK65X0818Accident · No injuriesClosedCessna 172 · Mesa, WANov 24, 1964 · N7362T · Destroyed NTSB UNK65X0797Accident · No injuriesClosedCessna 170B · Peoria, ILNov 22, 1964 · N4316B · Substantial damage NTSB UNK65X0796Accident · No injuriesClosedCessna 172 · East Prairie, MONov 22, 1964 · N6833A · Substantial damage NTSB UNK65X0774Accident · Minor injuriesClosedCessna 172 · Lorenzo, TXNov 21, 1964 · N8111X · Substantial damage NTSB UNK65X0762Accident · No injuriesClosedCessna 172 · Cedar Lake, MINov 20, 1964 · N5769A · Destroyed NTSB UNK65X0754Accident · No injuriesClosedCessna 172 · Louisa County, VANov 19, 1964 · N7912X · Substantial damage NTSB UNK65X0730Accident · 1 fatalClosedCessna 172 · Caddo Lake, LANov 15, 1964 · N8268X · Destroyed NTSB UNK65X0673Accident · No injuriesClosedCessna 172 · Oxnard, CANov 12, 1964 · N7501X · Substantial damage NTSB UNK65X0666Accident · No injuriesClosedCessna 172B · Cleveland, OHNov 12, 1964 · N8170X · Substantial damage NTSB UNK65X0646Accident · No injuriesClosedCessna 172B · Lubbock, TXNov 10, 1964 · N2182Y · Substantial damage NTSB UNK65X0597Accident · No injuriesClosedCessna 172 · Lawton, OKNov 7, 1964 · N3062U · Substantial damage NTSB UNK65X0573Accident · 2 fatalClosedCessna 172B · Mattituck, NYNov 5, 1964 · N5789T · Destroyed NTSB UNK65X0529Accident · No injuriesClosedCessna 172D · Santa Ana, CANov 2, 1964 · N2775U · Substantial damage NTSB UNK65X0508Accident · No injuriesClosedCessna 172 · Waller, TXNov 1, 1964 · N4101F · Substantial damage NTSB UNK65X0496Accident · No injuriesClosedCessna 172 · Theodore, ALOct 31, 1964 · N7426X · Substantial damage NTSB UNK65X0485Accident · No injuriesClosedCessna 172E · Lubec, MEOct 30, 1964 · N5561T · Substantial damage NTSB UNK65X0431Accident · No injuriesClosedCessna 172D · Broadus, MTOct 25, 1964 · N2379U · Substantial damage NTSB UNK65X0427Accident · No injuriesClosedCessna 172 · Manzanola, COOct 25, 1964 · N2812U · Substantial damage NTSB UNK65X0420Accident · No injuriesClosedCessna 172C · Columbus, OHOct 25, 1964 · N1397Y · Destroyed NTSB UNK65X0393Accident · No injuriesClosedCessna 172 · Marks, MSOct 24, 1964 · N3864S · Substantial damage NTSB UNK65X0391Accident · Serious injuriesClosedCessna 172 · Ralls, TXOct 23, 1964 · N7321T · Destroyed NTSB UNK65X0364Accident · Serious injuriesClosedCessna 172 · Van, TXOct 21, 1964 · N8233B · Destroyed NTSB UNK65X0359Accident · No injuriesClosedCessna 150 · Troutdale, OROct 21, 1964 · N6091T · Substantial damage NTSB UNK65X0308Accident · No injuriesClosedCessna 172 · Ouray, UTOct 17, 1964 · N5031A · Substantial damage NTSB UNK65X0282Accident · No injuriesClosedCessna 172 · Grand Canyon, AZOct 15, 1964 · N8118B · Substantial damage NTSB UNK65X0269Accident · No injuriesClosedCesna 172 · Amarillo, TXOct 13, 1964 · N4114F · Substantial damage NTSB UNK65X0244Accident · No injuriesClosedCessna 172 · El Monte, CAOct 11, 1964 · N7842T · Substantial damage NTSB UNK65X0241Accident · No injuriesClosedCessna 172 · Windom, KSOct 11, 1964 · N7536T · Substantial damage NTSB UNK65X0231Accident · No injuriesClosedCessna 170B · Tants River, AKOct 11, 1964 · N3480D · Destroyed NTSB UNK65X0223Accident · No injuriesClosedCessna 172 · Seville, OHOct 10, 1964 · N16QB · Substantial damage NTSB UNK65X0147Accident · No injuriesClosedCessna 170B · Laporte, TXOct 4, 1964 · N2604D · Substantial damage NTSB UNK65X0130Accident · No injuriesClosedCessna 170 · Las Vegas, NVOct 3, 1964 · N4392B · Substantial damage NTSB UNK65X0116Accident · No injuriesClosedCessna 172 · Alder Point, CAOct 2, 1964 · N6184E · Substantial damage NTSB UNK64X4097Accident · No injuriesClosedCessna 172E · Festus, MOSep 22, 1964 · N5347T · Substantial damage NTSB UNK64X4095Accident · No injuriesClosedCessna 172 · Carrington Is, UTSep 22, 1964 · N8926B · Substantial damage NTSB UNK64X4047Accident · Minor injuriesClosedCessna 172 · Hagerstown, MDSep 19, 1964 · N3703S · Substantial damage NTSB UNK64X3951Accident · No injuriesClosedCessna 172 · La Verne, CASep 13, 1964 · N2454U · 2 aircraft · Substantial damage NTSB UNK64X3900Accident · No injuriesClosedCessna 172 · Detroit, MISep 10, 1964 · N3661S · Substantial damage NTSB UNK64X3872Accident · No injuriesClosedCessna 172 · Louisville, MSSep 8, 1964 · N7991B · Substantial damage