Final NTSB investigations: Nardi FN-333

12 cases on aircraft the registry lists as Nardi FN-333. 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

Final NTSB investigations: Nardi FN-333 per year, 1964–2026: 12 cases
1964	2
1965	2
1968	3
1970	1
1972	1
1974	1
1979	1
1984	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."completionStatus" = 'Completed' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('6080102')) 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.\"completionStatus\" = 'Completed'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('6080102'))
  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."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('6080102'))
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 CHI84LA291Accident · Serious injuriesLimited investigationFinal reportSIAI-Marchetti FN-333 · Lansing, MIThe acft was not flown for 6 yrs. During last annual inspection, 67 hrs of labor, the batteries (2), spark plug gaskets,magneto gaskets, battery cable lugs and impulse coupling were replaced. The fuel quantity transmitter, battery, magnetos and spark plugs…Jul 12, 1984 · N912NS · Destroyed NTSB FTW79FPG31Accident · No injuriesClosedNardi FN-333 · Hot Springs, ARMay 1, 1979 · N913NS · Substantial damage NTSB MIA74AM098Accident · 1 fatalClosedNardi FN-333 · Tallahassee, FLMay 24, 1974 · N628 · Substantial damage NTSB MKC73FTK06Accident · No injuriesClosedNardi FN-333 · Canton, SDOct 3, 1972 · N623 · Substantial damage NTSB NYC71AN031Accident · 2 fatalClosedNardi FN-333 · Shelton, CTAug 30, 1970 · N917NS · Destroyed NTSB CHI69A0045Accident · 1 fatalClosedNardi FN-333 · Akron, OHOct 25, 1968 · N625 · Destroyed NTSB LAX69F0159Accident · Serious injuriesClosedNardi FN333 · Pomona, CAOct 15, 1968 · N913NS · Substantial damage NTSB MIA69F0217Accident · No injuriesClosedNardi FN-333 · Winter Haven, FLSep 2, 1968 · N626 · Substantial damage NTSB CHI66F0300Accident · Serious injuriesClosedNardi FN333 · Three Lakes, WIAug 19, 1965 · N624 · Destroyed NTSB NYC65D0168Accident · No injuriesClosedNardi FN333 · Secaucus, NJApr 17, 1965 · N632 · Substantial damage NTSB UNK65X0173Accident · Minor injuriesClosedNardi FN333 · Chandeleur Is, LAOct 7, 1964 · N622 · Destroyed NTSB UNK64X2090Accident · No injuriesClosedRiviera FN333 · Brookhaven, MSJun 3, 1964 · N623 · Substantial damage