NTSB investigations: Pitts Special S-1C
25 cases on aircraft the registry lists as Pitts Special S-1C. 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
| 1965 | 1 |
|---|---|
| 1967 | 1 |
| 1968 | 3 |
| 1969 | 1 |
| 1970 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 4 |
| 1976 | 1 |
| 1978 | 2 |
| 1979 | 3 |
| 1983 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 1999 | 1 |
| 2017 | 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 c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('72202TG', '72202S9', '72202SL', '72202UC', '72202VU', '72202R7', '72202SE', '72202SJ', '72202SR', '72202ST', '72202SW', '72202SX', '72202TR', '72202TY', '72202UP', '72202UT', '72202VE', '72202VS', '72202VW', '72202VX', '72202R8', '72202R9', '72202RJ', '72202S1', '72202SF', '72202SH', '72202SM', '72202SN', '72202SZ', '72202TC', '72202TH', '72202TJ', '72202TW', '72202TX', '72202UM', '72202VP', '72202VZ'))
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 ('72202TG', '72202S9', '72202SL', '72202UC', '72202VU', '72202R7', '72202SE', '72202SJ', '72202SR', '72202ST', '72202SW', '72202SX', '72202TR', '72202TY', '72202UP', '72202UT', '72202VE', '72202VS', '72202VW', '72202VX', '72202R8', '72202R9', '72202RJ', '72202S1', '72202SF', '72202SH', '72202SM', '72202SN', '72202SZ', '72202TC', '72202TH', '72202TJ', '72202TW', '72202TX', '72202UM', '72202VP', '72202VZ'))
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 GAA17CA144Accident · No injuriesData collectionFinal reportPitts Special S 1C · Borger, TXThe pilot’s failure to maintain directional control of the biplane during takeoff.NTSB FTW99LA181Accident · Minor injuriesLimited investigationFinal reportPitts Special S-1C · Temple, TXThe loss of engine power due to fuel starvation, as a result of fuel moving away from the fuel supply outlets during maneuvering with a low fuel level, and the pilot's failure to maintain clearance with the power lines during the ensuing forced landing.NTSB LAX96LA020Accident · No injuriesLimited investigationFinal reportPitts Special S-1C · San Carlos, CAthe pilot's misjudged landing approach, failure to achieve the proper touchdown point, and his delayed decision to abort the landing.NTSB NYC92LA110Accident · No injuriesLimited investigationFinal reportJames J. Dean Pitts Special S1C · Newburyport, MAThe pilot misjudging his clearance to brush and small trees during landing rollout.NTSB ATL91FA005Accident · 1 fatalField investigationFinal reportPitts Special S-1 · Ocala, FLThe pilot experiencced spatial disorientation, lost control of the airplane during a spin maneuver and collided with the ground.NTSB MIA83LA205Accident · No injuriesLimited investigationFinal reportPitts S-1C · Kissimmee, FLWhile cruising at 2000 ft MSL the eng lost pwr. The plt restarted the eng 3 times but was forced to lnd when it would not develop pwr. During lndg roll in a cow pasture the acft collided with a fence post, ground looped, and turned our on its back. The fuel…NTSB CHI79FEI33Accident · 1 fatalClosedPitts S1 · Warren, OHNTSB FTW79FRA24Accident · 1 fatalClosedPitts S1C · Morgan Point, TXNTSB MIA79FKG41Accident · 1 fatalClosedPitts Spec S-1 · Warner Robins, GANTSB CHI78DEI25Accident · No injuriesClosedPitts S-1C · Archbold, OHNTSB IAD78FID07Accident · Minor injuriesClosedPitts S-1 · Fredericksburg, VANTSB IAD76FID44Accident · 1 fatalClosedPitts Spcl S-1C · Weyers Cave, VANTSB MKC75FTG14Accident · No injuriesClosedPitts S1C · Erie, NDNTSB LAX74FUG09Accident · 1 fatalClosedPitts SPL S-1C · Highgrove, CANTSB MIA75FLD12Accident · No injuriesClosedPitts SC1 · St Petersburg, FLNTSB MKC75FER16Accident · Serious injuriesClosedZimmerman S-1C · Waseca, MNNTSB FTW73DRG79Accident · No injuriesClosedPitts S1C · Boerne, TXNTSB OAK73DVD13Accident · Minor injuriesClosedPitts Spec S-1C · Tracey, CANTSB OAK71DVM10Accident · No injuriesClosedPitts S1C · Santa Cruz, CANTSB DEN69D0197Accident · No injuriesClosedPitts Spcl SC-1 · El Paso, TXNTSB MIA69F0309Accident · No injuriesClosedPitts Spec S1C · Kendall, FLNTSB MIA69F0228Accident · 1 fatalClosedPitts S1C · Tampa, FLNTSB CHI69F0155Accident · 1 fatalClosedPitts Spec S-K · Napoleon, MINTSB LAX67A0108Accident · 1 fatalClosedPitts SPL S-1C · Hesperia, CANTSB DEN66F0176Accident · No injuriesClosedPitts Spcl S1C · Sunland Pk, NM