NTSB investigations: Cessna 150A, TX
15 cases on aircraft the registry lists as Cessna 150A. 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 | 2 |
|---|---|
| 1965 | 2 |
| 1966 | 3 |
| 1967 | 1 |
| 1968 | 1 |
| 1975 | 1 |
| 1976 | 1 |
| 1977 | 1 |
| 1978 | 1 |
| 1982 | 1 |
| 1991 | 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 ('2071804'))
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 ('2071804'))
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 FTW91LA139Accident · Minor injuriesLimited investigationFinal reportCessna 150A · Jewett, TXPremature retraction of the flaps near the ground at slow airspeed. A factor was the attempted low pass.NTSB FTW82DA256Accident · No injuriesFinal reportCessna 150A · Fabens, TXThe pilot reported that on a flight from midland to el paso, TX, he encountered marginal weather. Flight watch had reported rain and thunderstorm activity about 30 miles east of el paso. As the weather on his route worsened and became more turbulent, he…NTSB FTW79DQG09Accident · No injuriesClosedCessna 150 · Midland, TXNTSB FTW77DRG23Accident · No injuriesClosedCessna 150 · Rio Grand City, TXNTSB FTW77FA010Accident · 2 fatalClosedCessna A150M · Cypress, TXNTSB FTW75FPD29Accident · No injuriesClosedCessna 150 · Granbury, TXNTSB FTW68F0617Accident · No injuriesClosedCessna 150 · Lewisville, TXNTSB FTW68D0092Accident · No injuriesClosedCessna 150 · Arlington, TXNTSB FTW67F0306Accident · No injuriesClosedCessna 150A · Abilene, TXNTSB FTW67F0323Accident · No injuriesClosedCessna 150 · San Antonio, TXNTSB FTW67D0256Accident · No injuriesClosedCessna 150 · Pearsall, TXNTSB FTW66D0252Accident · No injuriesClosedCessna 150 · Clarendon, TXNTSB FTW66D0287Accident · No injuriesClosedCessna 150 · Edinburg, TXNTSB UNK65X0868Accident · 1 fatalClosedCessna 150 · Georgetown, TXNTSB UNK64X0207Accident · No injuriesClosedCessna 150A · Italy, TX