NTSB investigations, AK
135 cases where the first occurrence was “Nose over”.
Cases per year
| 1982 | 9 |
|---|---|
| 1983 | 8 |
| 1984 | 10 |
| 1985 | 8 |
| 1986 | 6 |
| 1987 | 3 |
| 1988 | 5 |
| 1989 | 11 |
| 1990 | 7 |
| 1991 | 7 |
| 1992 | 5 |
| 1993 | 7 |
| 1994 | 8 |
| 1995 | 8 |
| 1996 | 7 |
| 1997 | 2 |
| 1998 | 5 |
| 2000 | 1 |
| 2001 | 2 |
| 2002 | 4 |
| 2003 | 4 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 3 |
| 2007 | 3 |
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\" = 'AK' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 300)
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" = 'AK' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 300) 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 ANC08CA022Accident · No injuriesData collectionFinal reportAeronca 7JC · Wasilla, AKThe pilot's excessive application of the airplane's brakes during the landing roll, which resulted in a nose-over.NTSB ANC08CA001Accident · No injuriesData collectionFinal reportRittal Glastar · Girdwood, AKThe pilot's excessive use of the brakes during the landing roll, which resulted in a nose over.NTSB ANC07TA080Accident · No injuriesFinal reportPiper PA-18 · McGrath, AKThe pilot's failure to maintain control of the airplane during the landing roll. Contributing to the accident was rough and uneven terrain conditions.NTSB ANC06CA077Accident · No injuriesData collectionFinal reportChristen Industries A-1 · Takotna, AKThe pilot's excessive use of brakes during the landing roll. A factor associated with the accident was soft terrain.NTSB ANC06CA040Accident · No injuriesData collectionFinal reportCessna 170B · Palmer, AKThe pilot's selection of unsuitable terrain for landing, which resulted in the airplane nosing over during the landing roll. A factor associated with the accident was the snow covered terrain.NTSB ANC06CA019Accident · No injuriesData collectionFinal reportKenetic Mountain Goat · Palmer, AKThe pilot's selection of unsuitable terrain for taxi, which resulted in the airplane nosing over while taxiing after landing. A factor associated with the accident was the rough and uneven terrain.NTSB ANC05CA103Accident · No injuriesData collectionFinal reportCessna 172 · Kenai, AKThe pilot's selection of an unsuitable landing area, which resulted in a nose over. A factor associated with the accident was swampy terrain.NTSB ANC04CA116Accident · No injuriesData collectionFinal reportPiper PA-18-180 · Talkeetna, AKThe pilot's selection of an unsuitable landing area, which resulted in a nose over. A factor associated with the accident was tundra.NTSB ANC03CA110Accident · No injuriesData collectionFinal reportPiper PA-18-180 · Eagle, AKThe pilot's selection of an unsuitable landing area, and his excessive use of the airplane's brakes during the landing roll, resulting in a nose over. A factor associated with the accident was rough and uneven terrain.NTSB ANC03CA077Accident · No injuriesData collectionFinal reportPiper PA-18 · Talkeetna, AKThe pilot's selection of an unsuitable landing area, which resulted in an on ground encounter with soft terrain and subsequent nose over of the airplane. A factor associated with the accident was soft terrain.NTSB ANC03LA058Accident · Minor injuriesLimited investigationFinal reportCessna 140A · Anchorage, AKThe pilot's excessive application of the brakes during the landing roll of a short field landing, which resulted in the airplane nosing over.NTSB ANC03LA046Accident · Minor injuriesLimited investigationFinal reportAviat A1 · Anchorage, AKThe flight instructor's excessive application of the brakes during the landing roll, which resulted in the airplane nosing over.NTSB ANC03LA010Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Fairbanks, AKThe pilot's excessive use of brakes during the landing roll, which resulted in the nose over of the airplane.NTSB ANC03LA002Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Wasilla, AKThe instructor's inadequate supervision of the pilot-rated dual student, and the dual student's excessive use of brakes during the landing roll, which resulted in the nose over of the airplane.NTSB ANC02LA063Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Kotzebue, AKThe pilot's excessive braking action while landing on a sandbar, which resulted in a nose over.NTSB ANC02LA056Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Chugiak, AKThe pilot's excessive braking, which resulted in a noseover during landing. Factors associated with the accident were the pilot's improper touchdown point, and landing with a tailwind.NTSB ANC01LA124Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Palmer, AKThe pilot's excessive use of brakes during the landing roll.NTSB ANC01LA092Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Skwentna, AKThe pilot's excessive use of brakes during the landing roll.NTSB ANC00LA094Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Cordova, AKThe pilot's excessive application of the airplane's brakes.NTSB ANC98LA160Accident · No injuriesLimited investigationFinal reportPiper PA-18 · New Stuyahok, AKThe pilot's excessive use of brakes during the landing roll.NTSB ANC98LA142Accident · No injuriesLimited investigationFinal reportCessna 170B · Port Alsworth, AKThe solo student pilot's excessive application of brakes during taxi from landing. Factors associated with the accident were the pilot's selection of unsuitable terrain for a precautionary landing, rough terrain, and the fuel leak from the fuel tank vent.NTSB ANC98LA139Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Cordova, AKThe pilot's selection of an unsuitable off airport site for landing. A factor associated with the accident was high vegetation (brush and weeds) in the landing area.NTSB ANC98TA128Accident · No injuriesFinal reportPiper PA-18 · Fairbanks, AKThe pilot's inadequate preflight planning/preparation, and his delay in aborting the takeoff. Factors in the accident were a short runway area for takeoff, trees located at the end of the runway, and the pilot's excessive application of brakes.NTSB ANC98LA072Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Nikiski, AKThe pilot's use of excessive brake application during landing roll.NTSB ANC97LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKbinding or braking action of the left brake for undetermined reason(s).NTSB ANC97LA116Accident · No injuriesLimited investigationFinal reportCessna 180 · Port Ashton, AKThe pilot's selection of unsuitable terrain. Factors associated with the accident were the tailwind and soft terrain.NTSB ANC96LA167Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Noatak, AKThe pilot's selection of unsuitable terrain for landing.NTSB ANC96FA139Accident · 1 fatalField investigationFinal reportCessna 206 · Yakutat, AKThe pilot's landing on the water with the landing gear inadvertently extended.NTSB ANC96LA091Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Anchorage, AKThe flight instructor's excessive application of the brakes during the landing roll. A factor in the accident was the flight instructor's restricted view of the landing area.NTSB ANC96LA050Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Palmer, AKimproper planning/decision by the pilot, and his selection of unsuitable terrain on which to land a ski equipped airplane.NTSB ANC96LA055Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Paxson, AKthe student pilot's selection of an unsuitable off airport landing site. Factors associated with the accident were the soft and snow covered terrain.NTSB ANC96LA028Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Cooper Landing, AKthe pilot's selection of unsuitable terrain for landing. Soft snow conditions were a factor in the accident.NTSB ANC96LA170Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Skwentna, AKThe pilot's selection of an unsuitable site for landing. A factor associated with the accident is the snow-covered terrain.NTSB ANC96TA011Accident · Minor injuriesFinal reportBellanca 8GCBC · Fairbanks, AKThe pilot's inadequate recovery from a bounced landing. The snow-covered landing surface and the pilot's decision not to perform a go-around were factors.NTSB ANC96LA010Accident · No injuriesLimited investigationFinal reportCessna 185 · Kodiak, AKThe check pilot's inadequate compensation for wind conditions. Factors relating to the accident were: the rough water and adverse wind conditions.NTSB ANC96LA004Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tyonek, AKImproper planning/decision by the pilot concerning his method of testing the landing area. His selection of an unsuitable area was a related factor.NTSB ANC95LA145Accident · No injuriesLimited investigationFinal reportPiper PA-18A · Skwentna, AKThe pilot's improper planning/decision. A factor relating to the accident was: the pilot's selection of a short/uneven landing area that required excessive braking action while landing with a tailwind.NTSB ANC95LA096Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Homer, AKThe pilot's improper (excessive) use of the brakes after the airplane crested the landing site's crown and started downhill.NTSB ANC95LA064Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Big Delta, AKThe pilot's failure to maintain proper alignment with the landing surface. A factor relating to the accident was: the rough/uneven landing surface.NTSB ANC95TA054Accident · No injuriesFinal reportBellanca 8GCBC · Fairbanks, AKThe pilot's failure to verify the position of the parking brake knob prior to landing.NTSB ANC95GA083Accident · No injuriesFinal reportPiper PA-18 · Copper Center 2, AKThe pilot not using the checklist and landing with the skis pumped down.NTSB ANC95LA009Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Kenai, AKThe pilot's selection of unsuitable terrain for landing/taxi. Factors associated with the accident were the soft and snow covered terrain.NTSB ANC95LA007Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Palmer, AKThe pilot's selection of unsuitable terrain for landing. Snow covered terrain in the landing area was a factor in the accident.NTSB FTW94LA312Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Galena, AKThe pilot's excessive use of brakes during landing. A factor was the unfavorable winds at the remote landing area.NTSB FTW94LA307Accident · No injuriesLimited investigationFinal reportCessna 140 · Nenana, AKThe pilot's excessive use of the brakes during the aborted takeoff.NTSB ANC94LA116Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Skwentna, AKThe pilot's selecting a gravel bar for a normal landing. A factor was the soft spot in the gravel bar.NTSB ANC94LA092Accident · No injuriesLimited investigationFinal reportCessna A185F · Anchorage, AKThe pilot misjudged the landing flare. A factor in the accident was the glassy water.NTSB ANC94LA081Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Newtok, AKThe pilot's selection of unsuitable terrain.NTSB ANC94LA069Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Anchorage, AKThe pilot's excessive use of the wheel brakes.NTSB ANC93LA169Accident · No injuriesLimited investigationFinal reportCessna 180 · Sweet Lucy Lake, AKThe pilot in command's improper preflight planning and decision making. A factor in the accident was the high wind conditions.