NTSB investigations: Stinson 108-1, NY
15 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
| 1966 | 2 |
|---|---|
| 1967 | 1 |
| 1968 | 1 |
| 1969 | 3 |
| 1972 | 1 |
| 1973 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1980 | 1 |
| 1983 | 1 |
| 1988 | 1 |
| 1996 | 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\" = 'NY' 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" = 'NY' 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 NYC96LA130Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Elbridge, NYThe pilot's improper decision to use auto fuel and to fly the airplane when it was in need of major repairs and overdue its annual inspection.NTSB NYC88LA119Accident · Serious injuriesLimited investigationFinal reportStinson 108-1 · Poland, NYAfter several takeoffs in a southwesterly direction from a farm field, the student pilot attempted a takeoff downwind in an easterly direction and failed to clear the trees at the end of the field. The airplane crashed into the trees and terrain, and was…NTSB NYC83LA216Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Tully, NYAt 2,000 ft near syracuse the plt decided he had enough fuel to continue on to his home base at cortland. He added full power to climb back to 3,000 ft & encountered turbulence. With full power & 80 KTS indicated the acft was losing altitude. The acft…NTSB NYC80FFA17Accident · Minor injuriesClosedStinson 108-2 · Durhamville, NYNTSB NYC77FFJ22Accident · No injuriesClosedStinson 108-1 · Newark, NYNTSB NYC76DFJ19Accident · No injuriesClosedStinson 108-1 · Perry, NYNTSB NYC74FFA10Accident · No injuriesClosedStinson 108 · Albany, NYNTSB NYC72FHJ14Accident · No injuriesClosedStinson 108-1 · Deer Park, NYNTSB NYC70A0030Accident · 2 fatalClosedStinson 108-1 · Colton, NYNTSB NYC70D0129Accident · No injuriesClosedStinson 108 · Poestenkill, NYNTSB NYC70F0013Accident · Serious injuriesClosedStinson 108-1 · Babylon, NYNTSB NYC69F0004Accident · Minor injuriesClosedStinson 108-1 · Mendon, NYNTSB NYC68D0029Accident · No injuriesClosedStinson 108-1 · Brookhaven, NYNTSB NYC67F0040Accident · No injuriesClosedStinson 108-1 · Lindenhurst, NYNTSB NYC66F0604Accident · Minor injuriesClosedStinson 108-1 · Little Falls, NY