NTSB investigations, 2022
8 cases where the defining event was Landing area undershoot.
Cases per year
| 2008 | 14 |
|---|---|
| 2009 | 6 |
| 2010 | 11 |
| 2011 | 11 |
| 2012 | 8 |
| 2013 | 5 |
| 2014 | 3 |
| 2015 | 3 |
| 2016 | 12 |
| 2017 | 9 |
| 2018 | 8 |
| 2019 | 7 |
| 2020 | 4 |
| 2021 | 6 |
| 2022 | 8 |
| 2023 | 4 |
| 2024 | 4 |
| 2025 | 11 |
| 2026 | 2 |
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 year(c.\"eventDate\") = 2022
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '370')
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 year(c."eventDate") = 2022 AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '370') 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 DCA23WA099Incident · No injuriesClass 5 · ForeignBoeing 737-800 · Bangkok, ThailandNTSB ERA23LA074Accident · No injuriesClass 4 · LimitedFinal reportTextron 172 · Newnan, GAThe flight instructor’s inadequate remedial action during a simulated engine failure and low approach, which resulted in a collision with a runway light.NTSB GAA22WA316Accident · Serious injuriesClass 5 · ForeignCessna 208 · Al Ajban, United Arab EmiratesNTSB ANC22LA057Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft F19 · Lake Louise, AKThe pilot's failure to maintain a proper glide path, which resulted in a hard landing short of the airstrip.NTSB WPR22FA197Accident · 1 fatalClass 3 · FieldFinal reportCessna 208B · Oceanside, CAThe right-seated pilot’s failure to correct the left-seated pilot’s mismanagement of the engine thrust, which resulted in undesired speed and thrust oscillations during the final approach and a subsequent descent into terrain.NTSB ANC22LA026Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · Anchorage, AKThe flight instructor’s failure to adequately monitor the student pilot which resulted in an impact with terrain and a nose-over.NTSB ERA22LA145Accident · Serious injuriesClass 3 · LimitedFinal reportAirbus Helicopters MBB-BK 117 C-2 · Abingdon, VAThe pilot’s misalignment of the helicopter skids while landing on a dolly at night, which resulted in the skids becoming entangled with the dolly and a loss of control. Contributing to the accident was the pilot’s fatigue as a result of the time the accident…NTSB ANC22LA019Accident · No injuriesClass 4 · LimitedFinal reportDehavilland DHC-3 · Deadhorse, AKThe pilot's failure to maintain a proper approach path in flat light conditions, which resulted in landing short of the runway and impact with terrain.