NTSB investigations: Spartan 7W

9 cases on aircraft the registry lists as Spartan 7W. 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

NTSB investigations: Spartan 7W per year, 1969–2026: 9 cases
1969	2
1970	1
1972	1
1974	1
1981	1
1987	1
2000	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 ('8430302')) 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 ('8430302'))
  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 ('8430302'))
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 DEN08LA064Accident · No injuriesLimited investigationFinal reportSpartan 7W · Santa Fe, NMFatigue failure of the right main landing gear, rendering directional control impossible and causing an overload failure of the left main landing gear.Mar 12, 2008 · N17662 · Substantial damage NTSB NYC00LA190Accident · No injuriesLimited investigationFinal reportSpartan 7W · Jefferson, OHThe overload failure of the left main gear strut housing.Jul 6, 2000 · N17613 · Substantial damage NTSB ATL87LA144Accident · No injuriesLimited investigationFinal reportSpartan 7W · Sumter, SCThe plt reported that the airplane began to turn to the left after ldg when the tailwheel touched down; subsequent efforts to counteract the turn were not successful. The airplane ran off the side of the rwy and hit a depression in the terrain, collapsing the…Apr 25, 1987 · N13PH · Substantial damage NTSB MKC81DCQ47Accident · No injuriesClosedSpartan 7W · Phillipsburg, KSAug 3, 1981 · N17658 · Substantial damage NTSB LAX75FUD01Accident · No injuriesClosedSpartan 7W · Hawthorne, CAJul 8, 1974 · N17659 · Destroyed NTSB OAK72FXQ27Accident · No injuriesClosedSpartan 7W · Reno, NVApr 1, 1972 · N4444 · Substantial damage NTSB OAK71DVW14Accident · No injuriesClosedSpartan 7W · Pahrump, NVOct 4, 1970 · N17601 · Substantial damage NTSB CHI70F0288Accident · No injuriesClosedSpartan 7W · Joliet, ILAug 28, 1969 · N34SE · Substantial damage NTSB OAK70D0203Accident · No injuriesClosedSpartan 7W · Lemoore, CAJul 15, 1969 · N47W · Substantial damage