NTSB investigations: Cessna 150H, AZ
16 cases on aircraft the registry lists as Cessna 150H. 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
| 1968 | 1 |
|---|---|
| 1969 | 2 |
| 1970 | 1 |
| 1972 | 1 |
| 1975 | 2 |
| 1980 | 2 |
| 1981 | 1 |
| 1982 | 1 |
| 1986 | 2 |
| 1987 | 1 |
| 1992 | 1 |
| 2020 | 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\" = 'AZ' 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 ('2071818'))
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" = 'AZ' 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 ('2071818'))
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 WPR21LA005Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Rimrock, AZThe pilot’s improper landing flare, which resulted in a hard, bounced landing and runway excursion.NTSB LAX92LA104Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Ft Mojave, AZAn inadequate annual inspection performed by other maintenance personnel. Contributing to this accident was the flap cable failure due to corrosion.NTSB LAX87LA344Accident · No injuriesLimited investigationFinal reportCessna 150 · Marana, AZThe student pilot lost control of the airplane during landing roll on rwy 30. He indicated that the winds were from 280 deg at 9 KTS gusting to 12 KTS. The airplane veered right departing the rwy. The nose gear subsequently collapsed in rough and uneven…NTSB LAX86FA282Accident · 1 fatalField investigationFinal reportCessna 150H · Phoenix, AZThe plt performed 1 normal touch & go operation, & touched down normally on the second planed touch & go which was to terminate with a right dep out of the pattern. After touchdown, witnesses observed the acft roll straight along the rwy centerline for about…NTSB LAX86LA164Accident · No injuriesLimited investigationFinal reportCessna 150H · Tucson, AZThe pilot stated that after lowering the nosewheel during the landing, he heard a 'popping sound' and immediately raised the nosewheel off the runway. After the aircraft slowed and the pilot could no longer hold the nosewheel off, the aircraft veered to the…NTSB LAX82DA132Accident · No injuriesFinal reportCessna 150 · Tuscon, AZThe pilot stated that he filled the fuel tanks with 22 gallons of fuel. Three hours and 15 minutes after takeoff, he ran out of fuel. He made a forced landing about 1.5 miles from the intended destination and encountered desert shrubbery.NTSB LAX81DUJ93Accident · No injuriesClosedCessna 150 · Tucson, AZNTSB LAX80FUJ49Accident · No injuriesClosedCessna 150H · Kearny, AZNTSB LAX80DUJ46Accident · No injuriesClosedCessna 150H · Dolan Springs, AZNTSB LAX7LDUJ16Accident · No injuriesClosedCessna 150 · Phoenix, AZNTSB LAX75FUJ58Accident · No injuriesClosedCessna 150H · Cottonwood, AZNTSB LAX72DUJ70Accident · No injuriesClosedCessna 150 · Tuba City, AZNTSB LAX71DUJ38Accident · No injuriesClosedCessna 150H · Chandler, AZNTSB LAX70F0070Accident · No injuriesClosedCessna 150 · Phoenix, AZNTSB LAX70F0064Accident · No injuriesClosedCessna 150 · Peoria, AZNTSB LAX69D0087Accident · No injuriesClosedCessna 150 · Sahuarita, AZ