NTSB investigations: Stinson 108-1, PA
18 cases on aircraft the registry lists as Stinson 108-1. 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
| 1964 | 1 |
|---|---|
| 1965 | 2 |
| 1966 | 4 |
| 1967 | 2 |
| 1968 | 1 |
| 1969 | 2 |
| 1973 | 1 |
| 1974 | 1 |
| 1975 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2006 | 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.\"eventStateOrRegion\" = 'PA' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('9230404'))
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."eventStateOrRegion" = 'PA' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('9230404'))
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 NYC06CA200Accident · Minor injuriesData collectionFinal reportStinson 108 · Meadville, PAThe owner's failure to install the proper tailwheel spring clips, which resulted in a loss of directional control during the landing roll. A factor was his lack of a mechanic certificate.NTSB NYC01LA181Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Latrobe, PAThe pilot's failure to maintain control of the airplane which resulted in the inadvertent ground loop.NTSB NYC00LA043Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Grove City, PAThe flight instructor's failure to maintain control of the airplane during the landing rollout.NTSB NYC76DGM18Accident · No injuriesClosedStinson 108 · Listonburg, PANTSB NYC75DHA26Accident · No injuriesClosedStinson 108-1 · Spring City, PANTSB NYC73FGM31Accident · No injuriesClosedStinson 108-1 · Meadville, PANTSB NYC70F0151Accident · No injuriesClosedStinson 108-1 · Perkasie, PANTSB NYC69F0349Accident · Minor injuriesClosedStinson 108 · Aliquippa, PANTSB NYC69D0131Accident · No injuriesClosedStinson 108-1 · Central City, PANTSB NYC68F0030Accident · No injuriesClosedStinson 108-1 · Mt.Pocono, PANTSB NYC67D0495Accident · No injuriesClosedStinson 108-1 · Erie, PANTSB NYC67D0365Accident · No injuriesClosedStinson 108-1 · Leechburg, PANTSB NYC67D0042Accident · No injuriesClosedStinson 108-1 · Monroeville, PANTSB NYC67D0001Accident · No injuriesClosedStinson 108-1 · Mercer, PANTSB NYC66D0551Accident · No injuriesClosedStinson 108-1 · Mohrsville, PANTSB NYC66D0355Accident · No injuriesClosedStinson 108-1 · Mechanicsburg, PANTSB NYC66D0052Accident · No injuriesClosedStinson 108-1 · Bridgeville, PANTSB UNK65X0702Accident · No injuriesClosedStinson 108-1 · Collegeville, PA