NTSB investigations: Fleet 2

7 cases on aircraft the registry lists as Fleet 2. 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

19642026

NTSB investigations: Fleet 2 per year, 1964–2026: 7 cases
1964	1
1965	1
1973	1
1975	1
1980	1
2004	1
2008	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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1461202')) 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.aircraft_model_code IN ('1461202'))
  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.aircraft_model_code IN ('1461202'))
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 CHI08CA284Accident · No injuriesData collectionFinal reportFleet 2 · Leroy, OHThe loss of engine power due to the propeller hub failure during a low-level maneuver. Contributing to the accident were the trees encountered during the forced landing.Sep 17, 2008 · N764V · Substantial damage NTSB LAX04CA091Accident · No injuriesData collectionFinal reportFleet 2 · Fresno, CAthe pilot's failure to set the throttle friction lock, which resulted in the inadvertent application of the throttle, followed by a loss of directional control.Jan 10, 2004 · N606M · Substantial damage NTSB LAX80DXQ29Accident · Minor injuriesClosedFleet 2 · Imlay, NVJun 8, 1980 · N748V · Substantial damage NTSB NYC75FNA43Accident · No injuriesClosedFleet 2 · Norfolk, MAMay 22, 1975 · N1499T · Substantial damage NTSB IAD73FIA15Accident · No injuriesClosedFleet 2 · Huntington, MDMay 12, 1973 · N678M · Substantial damage NTSB FTW66D0006Accident · No injuriesClosedBrewster FLEET2 · Sonora, TXMar 12, 1965 · N678M · Substantial damage NTSB UNK65X0473Accident · No injuriesClosedBrewster FLEET1 · Mobile, ALOct 29, 1964 · N760V · Substantial damage