Skip to content

NTSB investigations · 16

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 ('2110124') 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 ('2110124')
  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 ('2110124')
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 WPR26LA165Accident · No injuriesClass 4 · LimitedFinal reportAeronca 7FC · Bend, ORThe pilot’s failure to maintain directional control during landing roll. Contributing to the accident was the rotor wash from a nearby helicopter.Apr 17, 2026 · N7541B · Substantial damage NTSB ERA25LA340Accident · No injuriesClass 4 · LimitedFinal reportChampion 7FC · Jackson, OHThe pilot’s failure to maintain directional control of the airplane during a touch-and-go landing.Sep 2, 2025 · N9884B · Substantial damage NTSB ERA19CA002Accident · Serious injuriesData collectionFinal reportChampion 7FC · Myakka City, FLThe pilot's failure to maintain clearance from an obstacle during takeoff.Oct 4, 2018 · N9855B · Substantial damage NTSB MKC86LA068Accident · No injuriesLimited investigationFinal reportAeronca 7FC · Lake City, ARThe flight instructor and his student touched down on the newly constructed private dirt strip in the airplane and rolled for 610 feet before the main gear bogged down. The nosewheel then cocked sideways and the airplane rolled forward to the inverted…Mar 15, 1986 · N9848Y · Substantial damage NTSB SEA70AS032Accident · 1 fatalClosedAeronca 7FC · Snohomish, WAFeb 8, 1970 · N9057B · 2 aircraft · Destroyed NTSB SEA68F0116Accident · No injuriesClosedChampion 7FC · Billings, MTAug 28, 1967 · N9886B · Substantial damage NTSB CHI67F0480Accident · Minor injuriesClosedAeronca 7FC · Walbridge, OHJan 13, 1967 · N7504B · Destroyed NTSB MKC67F0330Accident · 1 fatalClosedChampion 7FC · Forest Lake, MNDec 3, 1966 · N9034B · Destroyed NTSB CHI66F0607Accident · No injuriesClosedChampion 7FC · Circleville, OHMar 14, 1966 · N9890B · Substantial damage NTSB NYC66D0159Accident · Minor injuriesClosedChampion 7FC · Easton, MDJul 21, 1965 · N9863Y · Substantial damage NTSB LAX66D0023Accident · No injuriesClosedChampion 7FC · San Diego, CAJun 19, 1965 · N9073B · Substantial damage NTSB NYC66D0111Accident · No injuriesClosedChampion 7FC · Laytonsville, MDMar 27, 1965 · N9014B · Substantial damage NTSB UNK64X4058Accident · Minor injuriesClosedChampion 7FC · Humacao, PRSep 20, 1964 · N8915R · Substantial damage NTSB UNK64X2729Accident · Minor injuriesClosedChampion 7FC · Blaine, MNJul 9, 1964 · N7501B · Substantial damage NTSB UNK64X1316Accident · No injuriesClosedChampion 7FC · Miamisburg, OHApr 14, 1964 · N7566B · Substantial damage NTSB UNK64X1267Accident · 2 fatalClosedChampion 7FC · Tortugas, NMApr 11, 1964 · N7688E · Destroyed

Back to Aeronca 7FC