Skip to content

NTSB investigations · 18

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 ('0190920') 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 ('0190920')
  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 ('0190920')
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 CEN19TA196Accident · No injuriesFinal reportAeronca 65 C · Gilliam, LAThe pilot's failure to see and avoid a dark-colored utility pole while taxiing for takeoff.Jun 26, 2019 · N22173 · Substantial damage NTSB CEN13CA224Accident · No injuriesData collectionFinal reportAeronca 65C · Grand Rapids, MNThe student pilot’s failure to adequately lock the primer before takeoff and the flight instructor's failure to verify that the primer was adequately locked.Mar 23, 2013 · N21301 · Substantial damage NTSB IAD02LA097Accident · Serious injuriesLimited investigationFinal reportAeronca 65-C · Front Royal, VAThe pilot's failure to maintain airspeed, which resulted in an inadvertent stall/spin. A factor was the airplane's proximity to the ground when the spin commenced.Sep 29, 2002 · N24277 · Substantial damage NTSB FTW98LA228Accident · Minor injuriesLimited investigationFinal reportAeronca 65-C · Ozark, ARThe pilot's failure to maintain aircraft control.May 17, 1998 · N23548 · Substantial damage NTSB ATL97LA004Accident · Serious injuriesLimited investigationFinal reportAeronca 65-C · Angier, NCThe Aeronca 65's pilots selection of the wrong taxi route, and his inadequate visual lookout during back taxi.Oct 13, 1996 · N23927 · 2 aircraft · Substantial damage NTSB SEA89LA185Accident · No injuriesLimited investigationFinal reportAeronca 65-C · New Meadows, IDImproper planning/decision by the pilot, which resulted in fuel exhaustion due to an inadequate supply of fuel.Jun 26, 1989 · N22137 · Substantial damage NTSB CHI80FET20Accident · No injuriesClosedAeronca 65C · Ft.Wayne, INJul 15, 1980 · N23547 · Substantial damage NTSB SEA76FYI21Accident · No injuriesClosedAeronca 65C · Elmira, ORJun 26, 1976 · N22116 · Substantial damage NTSB IAD74FIG27Accident · Serious injuriesClosedAeronca 65-C · Rocks State Pk, MDMay 18, 1974 · N24277 · Substantial damage NTSB NYC74AN016Accident · 1 fatalClosedAeronca 11AC · Prospect, PAAug 18, 1973 · N23518 · Substantial damage NTSB CHI70D0350Accident · No injuriesClosedAeronca 65-TC · Detroit, MINov 15, 1969 · N23549 · Substantial damage NTSB NYC69D0353Accident · No injuriesClosedAeronca 65-C · Scranton, PAMar 16, 1969 · N22476 · Substantial damage NTSB NYC68F0144Accident · No injuriesClosedAeronca 65-C · Vincentown, NJAug 20, 1967 · N23927 · Substantial damage NTSB NYC66F0537Accident · Serious injuriesClosedAeronca 65-C · Waterloo, NYMar 13, 1966 · N24270 · Destroyed NTSB MKC66F0435Accident · Minor injuriesClosedAeronca 50C · St Francisvill, MOFeb 26, 1966 · N21340 · Substantial damage NTSB CHI66F0672Accident · Minor injuriesClosedAeronca 65-C · Kalkaska, MIJan 29, 1966 · N21303 · Substantial damage NTSB UNK65X0172Accident · No injuriesClosedAeronca 65C · Dalton, PAOct 7, 1964 · N22392 · Substantial damage NTSB UNK64X1414Accident · Minor injuriesClosedAeronca 65C · Excelsior Spgs, MOApr 22, 1964 · N21380 · Substantial damage

Back to Aeronca 65-C