NTSB investigations: Aviat PITTS S-2B, 1994
5 cases on aircraft the registry lists as Aviat PITTS S-2B. 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.
Cases per year
| 1983 | 1 |
|---|---|
| 1992 | 2 |
| 1993 | 1 |
| 1994 | 5 |
| 1997 | 1 |
| 1998 | 3 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 2 |
| 2003 | 3 |
| 2004 | 2 |
| 2006 | 2 |
| 2010 | 1 |
| 2011 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2025 | 1 |
Where
Open the mapLatest cases
Query with SQL
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 year(c.\"eventDate\") = 1994
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2210308', '2210403'))
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 year(c."eventDate") = 1994
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2210308', '2210403'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 SEA95LA032Accident · Minor injuriesLimited investigationFinal reportPitts S-2B · Afton, WYThe pilot's failure to maintain directional control, and his inadequate remedial action. Factors include snow covered terrain at the edge of the runway.NTSB MIA94LA171Accident · No injuriesLimited investigationFinal reportPitts S2B · Fort Lauderdale, FLThe poor welding quality of the manufacturer, resulting in the fatigue failure of the aileron attachment bracket.NTSB MIA94LA154Accident · No injuriesLimited investigationFinal reportPitts S2B · Keystone Height, FLThe pilot-in-command's exceeding of the design limitations of the airplane.NTSB LAX94LA194Accident · 1 fatalLimited investigationFinal reportPitts S-2A · Kahuku, HIThe failure of the pilot to maintain aircraft control due to spatial disorientation while performing an acrobatic routine. A factor in the accident was the low altitude at which the pilot was performing the acrobatic maneuvers.NTSB NYC94LA070Accident · No injuriesLimited investigationFinal reportAviat Pitts S-2B · Albion, NYthe pilot's loss of directional control during the landing roll, and the subsequent collision with soft terrain and nose over. Factors related to the accident were: the snowbanks on either side of the runway, and the pilot's lack of recent flight experience.