NTSB investigations, AZ
6 cases where the sequence of events included Landing area overshoot.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 1 |
| 2010 | 1 |
| 2022 | 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '380' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '380' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 WPR26FA151Accident · 2 fatalClass 3 · FieldPreliminary reportPiper PA-32R-301T · Marana, AZOn April 08, 2026 at 1710 mountain standard time, a Piper PA-32R-301T, N4190E, sustained substantial damage when it was involved in an accident near Marana, AZ. The pilot and passenger sustained fatal injuries. The airplane was operated as a Title 14 Code of…NTSB WPR23LA028Accident · No injuriesClass 3 · LimitedFinal reportEclipse Aerospace EA500 · Mesa, AZMaintenance personnel’s failure to properly align the right brake wheel speed transducer, which rendered the right wheel brake ineffective during landing, and the pilot’s subsequent failure to follow the correct procedures to restore braking action during the…NTSB WPR11CA026Accident · No injuriesData collectionFinal reportCessna 340A · Camp Verde, AZThe pilot's misjudged approach and failure to attain the correct touchdown point, which resulted in a runway overrun.NTSB WPR09LA168Accident · No injuriesLimited investigationFinal reportCessna 182Q · Sedona, AZThe pilot's failure to achieve the proper touchdown point during a full-stop landing attempt. Contributing to the accident were the pilot's failure to ensure that the aircraft was properly configured for landing, his not initiating a go-around, and a…NTSB LAX08CA252Accident · No injuriesData collectionFinal reportCessna 152 · Glendale, AZThe student pilot's misjudged altitude and distance, and failure to attain the proper touchdown point, that led to a landing overrun.NTSB SEA08LA082Accident · Serious injuriesLimited investigationFinal reportRaytheon 1900D · Kayenta, AZThe flight crew's failure to execute a missed approach, which resulted in a runway excursion after landing. Contributing to the accident were the inoperative lights, weather conditions below published approach minimums, and the slush contaminated runway.