Fatal NTSB investigations: Forney F-1

6 cases on aircraft the registry lists as Forney F-1. 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 per year

19692026

Fatal NTSB investigations: Forney F-1 per year, 1969–2026: 6 cases
1969	1
1970	1
1980	2
1993	1
1996	1

Where

Open the map

Latest cases

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."highestInjuryLevel" = 'Fatal' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0420202')) 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.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0420202'))
  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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('0420202'))
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 MIA97FA043Accident · 1 fatalField investigationFinal reportForney F-1 · Middleburg, FLVFR flight by the noninstrument-rated pilot into instrument meteorological conditions (IMC), which resulted in spatial disorientation and an uncontrolled descent into a wooded area. Factors relating to the accident were: failure of the pilot to obtain a…Dec 22, 1996 · N7530C · Destroyed NTSB MIA93FA065Accident · 2 fatalField investigationFinal reportForney Ercoupe F-1 · Aguadilla, PRExcessive elevator control input by an unknown occupant at an airspeed above maneuvering speed which caused both forward wing spars to fail. Contributing to the accident was fuel exhaustion due to poor in flight planning/decision by the pilot-in-command and…Feb 8, 1993 · N7555C · Destroyed NTSB MIA81FA027Accident · 2 fatalClosedErco 415-C · Lakeland, FLDec 21, 1980 · N2106H · 2 aircraft · Substantial damage NTSB DEN80FA030Accident · 1 fatalClosedForney F-1 · Ft.Collins, COApr 20, 1980 · N6133C · Destroyed NTSB NYC70AN122Accident · 2 fatalClosedForney F-1A · Myerstown, PAMay 23, 1970 · N7527C · Destroyed NTSB DEN70A0014Accident · 2 fatalClosedForney F-1 · Rancho Taos, NMAug 28, 1969 · N3010G · Destroyed