NTSB investigations: Aviat PITTS S-2B, 2003
3 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\") = 2003
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") = 2003
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 CHI04LA007Accident · 1 fatalLimited investigationFinal reportAviat Pitts S-2B · Cromwell, MNThe altitude/clearance not maintained by the pilot while performing aerobatic maneuvers. Contributing factors were the planning/decision to perform an aerobatic maneuver at a low altitude.NTSB NYC03FA088Accident · 2 fatalField investigationFinal reportAviat Pitts S-2B · Newport, PAThe pilot's improper decision to perform aerobatics at a low altitude, which inhibited his ability to recover from an encountered flat spin. A factor related to the accident was the aft center of gravity, which was beyond the operational limit for the…NTSB LAX03LA081Accident · Serious injuriesLimited investigationFinal reportPitts S-2B · Long Beach, CAThe pilot's excessive pull up, which resulted in a failure to obtain/maintain flying speed and a subsequent stall/mush.