NTSB investigations: Stol UC-1
9 cases on aircraft the registry lists as Stol UC-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
| 1977 | 1 |
|---|---|
| 1978 | 2 |
| 1983 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 2008 | 1 |
| 2014 | 1 |
| 2019 | 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 ('8640202'))
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 ('8640202'))
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 ERA19FA106Accident · 1 fatalClass 2 · FieldFinal reportStol UC-1 · Winter Haven, FLA total loss of left engine power for reasons that could not be determined, and the instructor's failure to maintain airspeed while maneuvering for a forced landing, which resulted in a loss of control. Contributing to the accident was the instructor's…NTSB CEN15LA038Accident · Minor injuriesLimited investigationFinal reportStol UC 1 · Jacksonville, TXThe loss of right engine power while climbing due to fuel starvation for reasons that could not be determined during postaccident airplane examination and testing, which led to a forced landing on hilly terrain.NTSB NYC08CA241Accident · Minor injuriesData collectionFinal reportStol UC-1 Twin Bee · Bunnell, FLThe flight instructor's inadequate recovery from a bounced landing.NTSB FTW96LA305Accident · No injuriesLimited investigationFinal reportStol UC-1 · Princeton, TXimproper adjustment of the left propeller governor which resulted in uncommanded feathering of the left propeller. Factors were: the airplane's inadequate engine out performance and the lack of suitable terrain for the forced landing.NTSB LAX95LA190Accident · 3 fatalLimited investigationFinal reportStol UC-1 · Saipan, Sarkan inflight collision with the ocean for undetermined reasons.NTSB MIA83FA227Accident · 1 fatalField investigationFinal reportStol UC-1 · Lake Hamilton, FLThe student was a commercial plt with ratings in single & multi-eng land & single eng sea acft. He was on his 1st flt in this make & model of acft to receve instruction for a multi-eng sea rating. After instructing water landings with flaps, the instructor…NTSB IAD78FIG15Accident · Serious injuriesClosedUnited Cons UC-1 · Edgewater, MDNTSB NYC78FA059Accident · 1 fatalClosedStol UC-1 · Champion, PANTSB NYC78FNC04Accident · No injuriesClosedRepublic UC1 · Harbor, ME