Skip to content

NTSB investigations · 17

Matched to the registry by N-number and event date, 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey WHERE a.aircraft_model_code IN ('0190902') 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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
  WHERE a.aircraft_model_code IN ('0190902')
  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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.aircraft_model_code IN ('0190902')
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 MIA00LA220Accident · No injuriesLimited investigationFinal reportAeronca 65-TC · Harris, NCThe unsuitable terrain encountered by the pilot while descending for a forced landing. Contributing to the accident was the partial loss of engine power due a blocked fuel line resulting in fuel starvation.Jul 12, 2000 · N29416 · Substantial damage NTSB FTW97FA099Accident · 2 fatalField investigationFinal reportAeronca 65-TC · Moriarty, NMThe pilot's failure to maitain airspeed resulting in an inadvertent stall/spin. Factors were gusty winds, turbulence, a high density altitude, and the pilot's lack of total experience in the make and model of aircraft.Feb 3, 1997 · N31794 · Substantial damage NTSB LAX82DA314Accident · No injuriesFinal reportAeronca 65-TC · Mira Loma, CAThe pilot reported that during flight, he ran out of fuel and the plane was damaged during a forced landing. An examination verified there was no preimpact, structural engine failure. Only residual fuel was found in the fuel filter, carburetor, header tank…Aug 21, 1982 · N29473 · Substantial damage NTSB CHI81FEM43Accident · No injuriesClosedAeronca 65-TC · Plainwell, MISep 7, 1981 · N31751 · Substantial damage NTSB FTW74AF090Accident · 1 fatalClosedAeronca 65-TC · San Antonio, TXJun 20, 1974 · N31426 · Destroyed NTSB MKC70DCJ22Accident · No injuriesClosedAeronca 65-TC · Fairmont, NEMay 16, 1970 · N29182 · Substantial damage NTSB SEA69A0057Accident · 1 fatalClosedAeronca 65-TC · Orchards, WAMay 20, 1969 · N27396 · Destroyed NTSB MIA70F0027Accident · Serious injuriesClosedAeronca 65-TC · Cartersville, GAApr 20, 1969 · N31387 · Destroyed NTSB MIA69F0261Accident · Serious injuriesClosedAeronca 65-TAC · Lafayette, TNNov 22, 1968 · N46605 · Destroyed NTSB MIA69A0001Accident · 1 fatalClosedAeronca 65-TC · Moultrie, GAJul 2, 1968 · N29476 · Destroyed NTSB CHI68F0709Accident · No injuriesClosedAeronca 65-TC · Lockport, ILMar 16, 1968 · N29413 · Substantial damage NTSB MKC68F0303Accident · No injuriesClosedAeronca 65-TC · Langdon, NDSep 25, 1967 · N31794 · Substantial damage NTSB DEN67F0068Accident · Serious injuriesClosedAeronca 65-TC · Greybull, WYJul 23, 1966 · N27392 · Substantial damage NTSB MIA65F0052Accident · Serious injuriesClosedAeronca 65TC · Hazlehurst, GAApr 10, 1965 · N31345 · Destroyed NTSB UNK65X0815Accident · Serious injuriesClosedAeronca 65TC · Salina, KSNov 24, 1964 · N34474 · Destroyed NTSB UNK64X1274Accident · No injuriesClosedAeronca 65TL · Smithfield, RIApr 12, 1964 · N31722 · Substantial damage NTSB UNK64X0366Accident · No injuriesClosedAeronca 65 · Milwaukee, WIJan 26, 1964 · N29416 · Substantial damage

Back to Aeronca 65-TC