NTSB investigations: Stinson L-5E
9 cases on aircraft the registry lists as Stinson L-5E. 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 |
| 1970 | 1 |
| 1971 | 1 |
| 1973 | 2 |
| 1984 | 1 |
| 1995 | 1 |
| 2015 | 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 ('8630210'))
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 ('8630210'))
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 GAA15CA249Accident · No injuriesData collectionFinal reportStinson L 5E · Tucson, AZThe pilot's failure to maintain directional control during the landing roll, resulting in a runway excursion and a collision with an object.NTSB LAX95LA260Accident · Minor injuriesLimited investigationFinal reportStinson L-5E · Elko, NVthe failure of the student pilot to maintain directional control and the inadequate supervision by the instructor pilot in taking timely corrective action.NTSB CHI84LA214Accident · No injuriesLimited investigationFinal reportStinson L-5E · Wooster, OHThe plt receiving instruction in landing conventional gear acft lost control during landing. The commercial PIC took control of the acft and his foot became jammed between the rudder pedal and airframe. The acft ground looped violently and nosed over.NTSB CHI74AC015Accident · 1 fatalClosedStinson L-5E · Demotte, INNTSB DEN74DTE06Accident · No injuriesClosedStinson L-5 · Fort Collins, CONTSB LAX72DUG23Accident · No injuriesClosedStinson L-5E · Elsinore, CANTSB LAX70DUG15Accident · No injuriesClosedStinson L-5 · Elsinore, CANTSB OAK67F0288Accident · No injuriesClosedStinson L-5 · Waianae, HINTSB NYC66D0373Accident · No injuriesClosedStinson L-5E · Mechanicsville, VA