NTSB investigations: Cessna 150D, TX
21 cases on aircraft the registry lists as Cessna 150D. 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 | 5 |
| 1966 | 3 |
| 1967 | 2 |
| 1968 | 1 |
| 1969 | 2 |
| 1971 | 1 |
| 1973 | 1 |
| 1975 | 1 |
| 1991 | 1 |
| 1994 | 1 |
| 2007 | 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 ('2071810'))
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 ('2071810'))
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 DFW07CA085Accident · Minor injuriesData collectionFinal reportCessna 150 · Brownfield, TXThe pilot's failure to maintain aircraft control while maneuvering. A contributing factor was the gusty wind conditions.NTSB FTW94LA067Accident · No injuriesLimited investigationFinal reportCessna 150D · Mount Pleasant, TXThe power loss due to carburetor icing and the pilot's delayed use of carburetor heat. Factors were the weather conditions and the lack of suitable terrain for the forced landing.NTSB FTW91LA061Accident · Serious injuriesLimited investigationFinal reportCessna 150D · San Ygnacio, TXPower loss due to carburetor ice and a malfunctioning carburetor heat control and the pilot's loss of control of the airplane.NTSB FTW75FPA17Accident · Serious injuriesClosedCessna 150D · Waco, TXNTSB FTW73AF072Accident · 1 fatalClosedCessna 150D · Monahans, TXNTSB FTW72FPD16Accident · No injuriesClosedCessna 150 · Wichita Falls, TXNTSB FTW70F0326Accident · Serious injuriesClosedCessna 150 · Dallas, TXNTSB FTW69F0460Accident · No injuriesClosedCessna 150 · Garland, TXNTSB FTW69F0136Accident · Serious injuriesClosedCessna 150 · Sulphur Srngs, TXNTSB FTW68F0200Accident · No injuriesClosedCessna 150 · Alvin, TXNTSB FTW67F0526Accident · No injuriesClosedCessna 150C · La Porte, TXNTSB FTW67D0126Accident · No injuriesClosedCessna 150D · Giddings, TXNTSB FTW67F0010Accident · No injuriesClosedCessna 150D · Midland, TXNTSB FTW66F0519Accident · No injuriesClosedCessna 150 · Dickinson, TXNTSB FTW66D0448Accident · No injuriesClosedCessna 150 · Houston, TXNTSB FTW66A0021Accident · 1 fatalClosedCessna 150D · Leander, TXNTSB FTW66F0110Accident · No injuriesClosedCessna 150 · Houston, TXNTSB FTW66D0001Accident · No injuriesClosedCessna 150 · Washburn, TXNTSB UNK65X1366Accident · No injuriesClosedCessna 150D · Ft Worth, TXNTSB UNK64X3518Accident · No injuriesClosedCessna 150 · Midland, TXNTSB UNK64X1281Accident · No injuriesClosedCessna 150 · Midland, TX