Skip to content

NTSB investigations, ID

20 cases where the first occurrence was “Nose over”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19862026

Where

Latest cases

Query with SQL

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" = 'ID' 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

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\" = 'ID' 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" = 'ID' 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 SEA06CA123Accident · No injuriesData collectionFinal reportSchweizer G-164B · Murtaugh, IDThe pilot's excessive brake application during the landing roll, which resulted in a nose over.Jun 17, 2006 · N3632T · Substantial damage NTSB SEA03LA171Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Emmett, IDThe pilot's failure to adequately compensate for a quartering tailwind during the initial part of the landing roll, and his failure to adequately decrease his brake applications to compensate for the tailwind conditions. Factors include, variable, gusting…Aug 17, 2003 · N185LC · Substantial damage NTSB SEA02LA183Accident · Minor injuriesLimited investigationFinal reportPiper/Cub Crafters PA-18 · Gannett, IDThe pilot's excessive braking during the landing rollout.Sep 28, 2002 · N380CC · Substantial damage NTSB SEA02LA149Accident · No injuriesLimited investigationFinal reportPiper PA-22/20 · Shearer, IDThe pilot's failure to maintain the proper approach speed while on final approach to the 2000 foot airstrip, and his excessive application of brakes while attempting to stop the aircraft during the resultant longer than normal landing roll. Factors include a…Aug 11, 2002 · N1573P · Substantial damage NTSB SEA02LA052Accident · No injuriesLimited investigationFinal reportSkystar Kitfox Lite Squared · Caldwell, IDThe pilot's failure to adequately compensate for the wind conditions. High and gusting winds were a factor.Mar 9, 2002 · N211TE · Substantial damage NTSB SEA01LA156Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Twin Falls, IDNose over during the landing roll for undetermined reasons.Aug 22, 2001 · N3632T · Substantial damage NTSB SEA01LA142Accident · No injuriesLimited investigationFinal reportCessna 150 · Blackfoot, IDPilot's failure to maintain directional control of the airplane while landing.Jul 21, 2001 · N10RH · Substantial damage NTSB SEA01LA006Accident · No injuriesLimited investigationFinal reportCessna 185F · Driggs, IDThe pilot's failure to maintain directional control. Factors include soft terrain adjacent to the runway.Oct 17, 2000 · N93981 · Substantial damage NTSB SEA99LA039Accident · No injuriesLimited investigationFinal reportCessna TU206G · Cascade, IDUnsuitable terrain for landing was selected. Snow covered airstrip was a factor.Mar 3, 1999 · N756AV · Substantial damage NTSB SEA98LA032Accident · No injuriesLimited investigationFinal reportCessna 180 · Sun Valley, IDthe pilot's inadvertent actuation of the parking brake.Jan 31, 1998 · N180AJ · Substantial damage NTSB SEA94LA222Accident · Minor injuriesLimited investigationFinal reportBoeing A75N1 · Caldwell, IDThe jamming of the right main landing gear brake due to an accumulation of a gummy deposit.Aug 28, 1994 · N73617 · Substantial damage NTSB SEA94LA224Accident · No injuriesLimited investigationFinal reportCessna 206 · Bliss, IDThe pilot's failure to maintain directional control. Factors include sunglare from the setting sun, and the soft terrain along the side the runway.Aug 27, 1994 · N859A · Substantial damage NTSB SEA93GA049Accident · No injuriesFinal reportPiper PA-18-135 · Council, IDThe pilot's failure to maintain proper altitude during the low pass. The snow covered terrain and the pilot's inadequate preflight preparation were factors.Jan 7, 1993 · N9841Q · Substantial damage NTSB SEA93LA037Accident · No injuriesLimited investigationFinal reportMaule M5-180C · Garden Valley, IDInadequate preflight planning and preparation. Factors include the snow covered runway.Dec 13, 1992 · N5652W · Substantial damage NTSB SEA92LA174Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Paul, IDThe pilot's selection of unsuitable terrain. The soft terrain was a factor.Aug 4, 1992 · N4653 · Substantial damage NTSB SEA92LA048Accident · No injuriesLimited investigationFinal reportCessna 172P · Nordman, IDThe pilot selected unsuitable terrain. Factors contributing to the accident were: the snow covered runway, and the pilot in command's inadequate preflight planning.Feb 17, 1992 · N96617 · Substantial damage NTSB SEA92LA032Accident · No injuriesLimited investigationFinal reportCessna 185 · Stanley, IDThe pilot-in-command's selection of unsuitable terrain (snow covered runway) for landing resulting in a nose over on landing rollout.Dec 27, 1991 · N113LC · Substantial damage NTSB SEA92LA008Accident · No injuriesLimited investigationFinal reportMcholland XPA-11 · Sandpoint, IDA poor in-flight decision. Contributing to the accident was the rough/uneven terrain.Oct 14, 1991 · N11XP · Substantial damage NTSB SEA89LA046Accident · No injuriesLimited investigationFinal reportCessna 180J · Elk City, IDThe pilot's failure to maintain a proper runway alignment on touchdown. Contributing to the accident were the soft snow conditions on the ranch airstrip.Jan 30, 1989 · N52095 · Substantial damage NTSB SEA86LA218Accident · No injuriesLimited investigationFinal reportCessna A185E · Soldier Bar Air, IDThe pilot was attempting to land on a 1600 foot runway with a tailwind. The density altitude at the time was about 6300 feet. During braking a gust of wind occurred and the aircraft nosed over inverted.Aug 22, 1986 · N1RC · Substantial damage