NTSB investigations: Cessna 152, UT
5 cases on aircraft the registry lists as Cessna 152, where the first occurrence was “Loss of control - in flight”. 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
| 1988 | 2 |
|---|---|
| 1996 | 3 |
Where
Latest 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\" = 'UT' 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 ('2071835')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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" = 'UT' 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 ('2071835')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 SEA97LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Salt Lake City, UTthe student pilot's improper in-flight planning/decision, which allowed his aircraft to encounter wake turbulence from a Lear Jet, and/or the student allowed the aircraft to stall. The crosswind component from the quartering headwind was a possible factor.NTSB SEA96LA149Accident · No injuriesLimited investigationFinal reportCessna 152 · Salt Lake City, UTthe student pilot's improper recovery from a bounced landing, and his failure to maintain adequate airspeed during go-around. The student pilot's improper level-off was a factor.NTSB SEA96LA084Accident · No injuriesLimited investigationFinal reportCessna 152 · Erda, UTfailure of the pilot to maintain directional control of the airplane during the landing. Darkness was a related factor.NTSB DEN89FA001Accident · 2 fatalField investigationFinal reportCessna 152 · Eden, UTBefore takeoff, the plt told ramp psnl that he & his wife were planning to take some pictures of the beautiful fall colors. A witness near the crash site observed an acft (matching the description of N48926) flying at low altitude. Subsequently, the acft…NTSB DEN88FA110Accident · 2 fatalField investigationFinal reportCessna 152 · Heber City, UTThe CFI and student plt were on a round-robin cross-country flt. A witness near the accident site said he saw an airplane flying 'up a canyon quite slow and low'. The airplane was reported overdue and found the next day in a 'box canyon' at the 8,500 foot…