NTSB investigations: Cessna A152, TX
7 cases on aircraft the registry lists as Cessna A152. 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
| 1979 | 2 |
|---|---|
| 1980 | 1 |
| 1981 | 1 |
| 1984 | 1 |
| 1995 | 1 |
| 1997 | 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\" = 'TX' 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 ('2071836'))
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" = 'TX' 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 ('2071836'))
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 FTW98LA017Accident · No injuriesLimited investigationFinal reportCessna A152 · Rockwall, TXThe pilot's improper recovery from a bounced landing and her failure to maintain directional control during the aborted landing. Factors were the wind gust and the turbulence.NTSB FTW95LA100Accident · 1 fatalLimited investigationFinal reportCessna A152 · Houston, TXThe pilot's inadequate supervision of the passenger. A factor was the pilot's inadequate preflight of the aircraft.NTSB FTW84LA332Accident · No injuriesLimited investigationFinal reportCessna A152 · Fort Worth, TXThe plt stated that he landed too FAR down the rwy & could not get the acft stopped prior to running off the end & colliding with a gas meter & a fence. He also stated that he should have gone around instead of continuing the landing attempt.NTSB FTW81DRA32Accident · No injuriesClosedCessna 152 · La Porte, TXNTSB FTW80FA036Accident · 2 fatalClosedCessna A152 · Lomax, TXNTSB FTW80FA014Accident · 2 fatalClosedCessna 152 · Lillian, TXNTSB FTW79DRG53Accident · No injuriesClosedCessna 152A · Junction, TX