NTSB investigations: Cessna A150L, AZ
5 cases on aircraft the registry lists as Cessna A150L. 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
| 1974 | 1 |
|---|---|
| 1997 | 1 |
| 1999 | 1 |
| 2025 | 1 |
| 2026 | 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 ('2071828'))
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 ('2071828'))
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 WPR26LA179Accident · No injuriesClass 4 · LimitedFinal reportCessna A150L · Superior, AZThe pilot's failure to retract the flaps during takeoff following a touch-and-go landing, which resulted in degraded climb performance and an impact with an object during an off-field landing.NTSB CEN25FA212Accident · 2 fatalClass 3 · FieldPreliminary reportCessna A150L · Three Points, AZOn June 18, 2025, about 0922 mountain standard time, a Cessna A150L airplane, N6436F, was substantially damaged when it was involved in an accident near Three Points, Arizona. The student pilot and flight instructor were fatally injured. The airplane was…NTSB LAX99LA154Accident · Serious injuriesLimited investigationFinal reportCessna A150L · Lake Mary, AZThe pilot's intentional buzzing and misjudged altitude/clearance with the nearby rising terrain. Contributing factors were the high density, the airplane's high gross weight, and the pilot's improper in-flight decisions.NTSB LAX97LA264Accident · No injuriesLimited investigationFinal reportCessna A150L · Quartzsite, AZThe student pilot's decision to land the airplane on a residential street, where the airplane subsequently hit a sign during the landing roll. Factors related to the accident were the student pilot becoming lost/disoriented during his cross country flight and…NTSB LAX75FUJ21Accident · No injuriesClosedCessna A150L · Marana, AZ