NTSB investigations, 2012, AK
18 cases where the sequence of events included Nose over/nose down.
Cases per year
| 2008 | 15 |
|---|---|
| 2009 | 22 |
| 2010 | 17 |
| 2011 | 26 |
| 2012 | 18 |
| 2013 | 19 |
| 2014 | 14 |
| 2015 | 13 |
| 2016 | 20 |
| 2017 | 20 |
| 2018 | 15 |
| 2019 | 27 |
| 2020 | 16 |
| 2021 | 22 |
| 2022 | 14 |
| 2023 | 19 |
| 2024 | 16 |
| 2025 | 14 |
| 2026 | 15 |
Where
Latest 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\") = 2012
AND c.\"eventStateOrRegion\" = 'AK' 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\" = '096' 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 year(c."eventDate") = 2012 AND c."eventStateOrRegion" = 'AK' 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" = '096' 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 ANC12LA113Accident · Minor injuriesLimited investigationFinal reportAviat A-1 · Fairbanks, AKThe pilot’s excessive application of brakes during landing, which resulted in a noseover.NTSB ANC12CA112Accident · No injuriesData collectionFinal reportPiper PA-12 · Fairbanks, AKThe pilot’s improper fuel management, which resulted in a loss of engine power due to fuel starvation.NTSB ANC12CA108Accident · No injuriesData collectionFinal reportCessna 172K · Atqasuk, AKThe student pilot's failure to maintain directional control while performing a high-speed taxi in windy conditions.NTSB ANC12CA099Accident · No injuriesData collectionFinal reportCessna 180 · Kenai, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over.NTSB ANC12CA102Accident · No injuriesData collectionFinal reportPiper PA-12 · Aniak, AKThe pilot's excessive use of brakes during the landing roll, which resulted in a nose over.NTSB ANC12CA094Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Delta Junction, AKThe pilot’s failure to identify the appropriate touchdown point, which resulted in a nose over.NTSB ANC12CA088Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Talkeetna, AKThe pilot's loss of control during the landing roll in gusting wind conditions, which resulted in the airplane nosing over.NTSB ANC12CA086Accident · No injuriesData collectionFinal reportPiper PA-18 · Anchorage, AKThe passenger's inadvertent application of the brake pedals during landing, which resulted in a noseover.NTSB ANC12CA078Accident · Minor injuriesData collectionFinal reportBellanca 7GCBC · Talkeetna, AKThe flight instructor's and student pilot's excessive application of brakes during an aborted takeoff, which resulted in a noseover.NTSB ANC12FA073Accident · 1 fatalField investigationFinal reportCessna U206G · Homer, AKThe pilot’s improper evaluation of the weather conditions and his subsequent downwind water landing in gusting wind conditions, which resulted in a nose-over.NTSB ANC12CA071Accident · No injuriesData collectionFinal reportBellanca 7GCBC · Fairbanks, AKThe pilot's excessive use of brakes during landing, which resulted in a noseover.NTSB ANC12LA064Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-180 · Chugiak, AKThe pilot/airplane owner’s loss of directional control after landing, and the instructor pilot's lack of adequate supervision of the training flight.NTSB ANC12LA061Accident · No injuriesLimited investigationFinal reportDehavilland Beaver DHC-2 MK.1 · Bettles, AKThe pilot’s failure to properly judge the airplane’s distance and altitude from the landing location during the final approach, which resulted in an undershoot and a nose over.NTSB ANC12CA044Accident · No injuriesData collectionFinal reportSilvaire Luscombe 8F · Tok, AKThe pilot's inadvertent and excessive application of brake pressure during landing, which resulted in a nose over.NTSB ANC12CA041Accident · No injuriesData collectionFinal reportDehavilland DHC-2 MK. I(L20A) · Talkeetna, AKThe pilot inadvertently landed with the parking brake set.NTSB ANC12CA023Accident · No injuriesData collectionFinal reportCessna 182A · Anchorage, AKThe pilot's inadvertent landing on a frozen lake in dark night conditions.NTSB ANC12CA022Accident · No injuriesData collectionFinal reportCessna 172I · McCarthy, AKThe pilot lost directional control during landing.NTSB ANC12CA020Accident · No injuriesData collectionFinal reportHelio H-295 · Old Minto, AKThe pilot's decision to land on unsuitable terrain, which resulted in the airplane nosing over.