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 UNK64X3850Accident · No injuriesClosedMaule M4 · Ft Wayne, INSep 7, 1964 · N4709T · Substantial damage NTSB UNK64X3839Accident · No injuriesClosedCessna 172 · Madison, CTSep 7, 1964 · N6471E · Substantial damage NTSB UNK64X3815Accident · No injuriesClosedCessna 172E · Flippin, ARSep 6, 1964 · N5427T · Substantial damage NTSB UNK64X3761Accident · No injuriesClosedCessna 172E · Champaign, ILSep 4, 1964 · N5715T · Substantial damage NTSB UNK64X3725Accident · No injuriesClosedCessna 172 · Candor, NCSep 1, 1964 · N1543Y · Substantial damage NTSB UNK64X3711Accident · No injuriesClosedCessna 172 · Delavan, WIAug 31, 1964 · N7481T · Substantial damage NTSB UNK64X3624Accident · No injuriesClosedCessna 172 · Lafayette, INAug 27, 1964 · N3020U · Substantial damage NTSB UNK64X3562Accident · No injuriesClosedCessna 172 · Colo Springs, COAug 23, 1964 · N7490T · Substantial damage NTSB UNK64X3477Accident · No injuriesClosedCessna 172 · Kelso, WAAug 19, 1964 · N7045T · Substantial damage NTSB UNK64X3455Accident · No injuriesClosedCessna 172 · Selma, CAAug 18, 1964 · N7195A · Substantial damage NTSB UNK64X3378Accident · No injuriesClosedCessna 172C · Williamsburg, VAAug 14, 1964 · N8249X · Substantial damage NTSB UNK64X3341Accident · No injuriesClosedCessna 172 · Goliad, TXAug 12, 1964 · N8349X · Substantial damage NTSB UNK64X3239Accident · No injuriesClosedCessna 172 · Ypsilanti, MIAug 6, 1964 · N5418T · Destroyed NTSB UNK64X3227Accident · No injuriesClosedCessna 172 · Ft Pierce, FLAug 5, 1964 · N6146E · Substantial damage NTSB UNK64X3207Accident · No injuriesClosedCessna 172 · Three Oaks, MIAug 4, 1964 · N5519T · Substantial damage NTSB UNK64X3147Accident · Minor injuriesClosedCessna 172 · Jackson, OHAug 1, 1964 · N7440X · Substantial damage NTSB UNK64X3135Accident · No injuriesClosedCessna 172 · Miami, FLJul 31, 1964 · N8485X · Substantial damage NTSB UNK64X3134Accident · Minor injuriesClosedCessna 172 · Thousand Is, NYJul 31, 1964 · N6803X · Substantial damage NTSB UNK64X3119Accident · No injuriesClosedCessna 172 · Deer Park, NYJul 30, 1964 · N1827Y · Substantial damage NTSB UNK64X3112Accident · Serious injuriesClosedCessna 172E · Ft Lauderdale, FLJul 29, 1964 · N5456T · No damage NTSB UNK64X3104Accident · No injuriesClosedCessna 172 · Clarion, PAJul 29, 1964 · N1304Y · Substantial damage NTSB UNK64X3064Accident · No injuriesClosedCessna 172 · Wilmington, DEJul 27, 1964 · N7790U · Substantial damage NTSB UNK64X3030Accident · No injuriesClosedCessna 172 · Rushville, INJul 25, 1964 · N2390U · Substantial damage NTSB UNK64X2929Accident · No injuriesClosedCessna 172D · Washington, INJul 19, 1964 · N2723U · Substantial damage NTSB UNK64X2913Accident · No injuriesClosedCessna 172 · Beltsville, MDJul 19, 1964 · N2434U · Substantial damage NTSB UNK64X2898Accident · No injuriesClosedCessna 170B · Isleboro, MEJul 18, 1964 · N3500C · Substantial damage NTSB UNK64X2896Accident · No injuriesClosedCessna 172 · Fresno, CAJul 18, 1964 · N6268E · Substantial damage NTSB UNK64X2822Accident · No injuriesClosedCessna 175A · Memphis, TNJul 14, 1964 · N7913T · Substantial damage NTSB UNK64X2777Accident · 1 fatalClosedCessna 172E · Milpitas, CAJul 12, 1964 · N5554T · Destroyed NTSB UNK64X2726Accident · No injuriesClosedCessna 170B · Wheatland, WYJul 9, 1964 · N3524C · Substantial damage NTSB UNK64X2669Accident · No injuriesClosedCessna 172 · Lake Tahoe, CAJul 5, 1964 · N2341U · Substantial damage NTSB UNK64X2593Accident · Minor injuriesClosedCessna 172B · Ocean City, MDJul 1, 1964 · N8052X · Substantial damage NTSB UNK64X2590Accident · No injuriesClosedCessna 172 · Rehobeth, DEJul 1, 1964 · N3949F · Substantial damage NTSB UNK64X2578Accident · No injuriesClosedCessna 170B · Albuquerque, NMJun 30, 1964 · N3444D · Substantial damage NTSB UNK64X2531Accident · No injuriesClosedCessna 172 · Clinton, ILJun 28, 1964 · N8841B · Substantial damage NTSB UNK64X2511Accident · No injuriesClosedCessna 172B · Menachemeadow, CAJun 27, 1964 · N7780X · Substantial damage NTSB UNK64X2478Accident · No injuriesClosedCessna 172 · Cloudland, GAJun 25, 1964 · N2492U · Substantial damage NTSB UNK64X2426Accident · No injuriesClosedCessna 172 · Three Oaks, MIJun 21, 1964 · N5508T · Substantial damage NTSB UNK64X2366Accident · No injuriesClosedCessna 172D · Los Angeles, CAJun 19, 1964 · N2754U · Substantial damage NTSB UNK64X2362Accident · No injuriesClosedCessna 172 · Anglemont Bc, CanadaJun 19, 1964 · N3578S · Substantial damage NTSB UNK64X2358Accident · Minor injuriesClosedCessna 172 · Chicago, ILJun 18, 1964 · N7863T · Substantial damage NTSB UNK64X2316Accident · Minor injuriesClosedCessna 172 · Van Buren, INJun 16, 1964 · N6498E · Substantial damage NTSB UNK64X2288Accident · No injuriesClosedCessna 172 · Cairo, GAJun 14, 1964 · N6886A · Substantial damage NTSB UNK64X2263Accident · Minor injuriesClosedCessna 172C · Severance, KSJun 13, 1964 · N1343Y · Substantial damage NTSB UNK64X2238Accident · No injuriesClosedDehavilland DH-104 · Detroit, MIJun 11, 1964 · N1300H · 2 aircraft · Substantial damage NTSB UNK64X2168Accident · No injuriesClosedCessna 172 · Page, AZJun 7, 1964 · N6221E · Substantial damage NTSB UNK64X2102Accident · No injuriesClosedCessna 172E · Canton, MSJun 4, 1964 · N3805S · Substantial damage NTSB UNK64X2075Accident · Minor injuriesClosedCessna 172B · Frazier Park, CAJun 2, 1964 · N7523X · Destroyed NTSB UNK64X2036Accident · No injuriesClosedMaule M-4 · Culbertson, MTMay 30, 1964 · N12032 · Substantial damage NTSB UNK64X2031Accident · Minor injuriesClosedCessna 172 · Nenana, AKMay 30, 1964 · N3562S · Substantial damage