NTSB investigations: Stinson L-5, CA
14 cases on aircraft the registry lists as Stinson L-5. 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 | 1 |
| 1966 | 1 |
| 1967 | 1 |
| 1968 | 1 |
| 1969 | 2 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1977 | 1 |
| 1981 | 1 |
| 1988 | 1 |
| 1990 | 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\" = 'CA' 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 ('8630202'))
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" = 'CA' 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 ('8630202'))
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 LAX90LA272Accident · Minor injuriesLimited investigationFinal reportStinson L-5B · Victorville, CAThe oil gauge line 'b' nut backed off, and the pilot failed to maintain airspeed.NTSB LAX88LA298Accident · No injuriesLimited investigationFinal reportStinson L-5 · Chino, CADuring the initial climb, the pilot reported that the engine lost power. The pilot initiated a forced landing and during the descent, the airplane collided with a fence coming to rest inverted. Fuel was observed to be leaking from the left wing. When the fuel…NTSB LAX81DVG37Accident · Minor injuriesClosedStinson L-5 · Calavares, CANTSB OAK78FVD03Accident · No injuriesClosedStinson L-5 · San Rafael, CANTSB OAK72FVM01Accident · No injuriesClosedStinson L-5 · San Jose, CANTSB LAX71DUG98Accident · No injuriesClosedStinson L5 · Elsinore, CANTSB OAK71FVG22Accident · Minor injuriesClosedStinson L-5 · Placerville, CANTSB LAX70F0083Accident · No injuriesClosedStinson L-5 · Elsinore, CANTSB LAX70F0084Accident · Minor injuriesClosedStinson L-5 · Daggett, CANTSB OAK69D0147Accident · No injuriesClosedStinson L-5 · Santa Clara, CANTSB OAK67D0324Accident · No injuriesClosedStinson L-5 · Dos Palos, CANTSB OAK67F0045Accident · No injuriesClosedStinson L5 MOD · Brentwood, CANTSB OAK66F0148Accident · Minor injuriesClosedStinson L-5 · Byron, CANTSB UNK65X0543Accident · No injuriesClosedStinson L5 · Castroville, CA