Skip to content

NTSB investigations, NC

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19822026

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" = 'NC' 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\" = 'NC' 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" = 'NC' 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 ATL05CA060Accident · Minor injuriesData collectionFinal reportSavage RV-8 · Goldsboro, NCThe pilot's excessive braking during landing roll, which resulted in a nose-over. A factor was the tailwind.Mar 9, 2005 · N187WS · Substantial damage NTSB ATL05CA057Accident · No injuriesData collectionFinal reportLuscombe 8A · Lexington, NCThe pilot's excessive braking during landing roll, which resulted in a nose-over. A factor was the tailwind.Mar 6, 2005 · N45524 · Substantial damage NTSB MIA01LA052Accident · No injuriesLimited investigationFinal reportCessna 305A · Morganton, NCThe failure of the pilot to maintain aircraft control about the aircraft's lateral axis during landing rollout, and the resultant nose over.Dec 27, 2000 · N143F · Substantial damage NTSB MIA00LA160Accident · Minor injuriesLimited investigationFinal reportDaniel A. Shapiro Searey 1DK · Morganton, NCThe inadvertent forward elevator input by the pilot-in-command while reducing throttle control resulting in the airplane nose-over.May 17, 2000 · N8096A · Substantial damage NTSB ATL99LA068Accident · Minor injuriesLimited investigationFinal reportVans RV-6A · Cedar Creek, NCThe soft runway surface.Apr 5, 1999 · N239RB · Substantial damage NTSB ATL97LA146Accident · No injuriesLimited investigationFinal reportCessna 172N · Fuquay-Varina, NCThe pilot's misjudged flare, improper level-off, and improper recovery from a bounced landing.Sep 26, 1997 · N75522 · Substantial damage NTSB ATL95LA133Accident · No injuriesLimited investigationFinal reportCessna 172 · Bayboro, NCThe pilot's inadequate procedure in that he elected to land the aircraft on unsuitable terrain with no mechanical malfunctions.Jul 12, 1995 · N13547 · Substantial damage NTSB ATL94LA152Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Vanceboro, NCThe pilot's improper use of wheel brakes.Aug 10, 1994 · N8896H · Substantial damage NTSB ATL93LA141Accident · No injuriesLimited investigationFinal reportCessna 150F · Wilmington, NCA hidden soft spot on the runway that resulted in a nose over of the airplane during a landing roll.Aug 1, 1993 · N6255R · Substantial damage NTSB MIA93LA024Accident · No injuriesLimited investigationFinal reportCessna 182B · Aberdeen, NCThe improper in flight decision of the pilot in command to attempt a long landing, downwind on a short wet sod runway. Contributing to the accident was the failure of the pilot in command to execute a go around when observing the wind and landing conditions.Dec 1, 1992 · N2649G · Substantial damage NTSB ATL91LA079Accident · No injuriesLimited investigationFinal reportCessna 120 · Pinebluff, NCThe pilot's delay in aborting the takeoff. The pilot's failure to calculate the aircraft's performance for the existing conditions was a factor related to the accident.Apr 6, 1991 · N46GB · Substantial damage NTSB ATL90LA004Accident · No injuriesLimited investigationFinal reportCessna 170 · Mooresville, NCImproper in-flight planning/decision by the pilot, which resulted in his failure to attain the proper toughdown point on the unidirectional runway. Factors related to the accident were: the unfavorable wind and terrain conditions.Oct 8, 1989 · N11575 · Substantial damage NTSB ATL88LA051Accident · No injuriesLimited investigationFinal reportCessna 172F · Eden, NCThe student plt attempted to land in a farm pasture adjacent to his brother's farm. The airplane ldg gear 'dug in' on ldg, and the airplane nosed over. The student plt described the terrain as 'wet & soggy'. The student did not have an instructor's…Dec 2, 1987 · N8674U · Substantial damage NTSB ATL88LA014Accident · No injuriesLimited investigationFinal reportCessna 152 · Murfreesboro, NCThe student plt became lost on the return leg of his 1st solo cross-country flt. He elected to make a precautionary ldg in a plowed field after observing the acft fuel gauges indicating near empty. The acft nosewheel sank into soft dirt during rollout and the…Oct 17, 1987 · N757AD · Substantial damage NTSB ATL87LA141Accident · No injuriesLimited investigationFinal reportCessna 150 · China Grove, NCDuring a supervised solo crosscountry flight, the student pilot reported that he got lost and was unable to visually locate his check point. After attempting to contact approach control for radar fixes, the pilot elected to make a precautionary landing in a…May 16, 1987 · N704EA · Substantial damage NTSB ATL85LA027Accident · No injuriesLimited investigationFinal reportCessna 180J · Harmony, NCThe commercial plt being checked in a tail wheel equipped acft by a CFI on board made 2 successful landings. During the 3rd landing roll, the acft nosed over. The student said that he applied 'heavy' braking during an attempted downslope, short field landing…Nov 7, 1984 · N7723K · Substantial damage NTSB ATL84LA157Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Wilmington, NCWhile the plt was taxiing after landing, one wheel of the acft mired in a soft spot. The acft then veered into softer terrain & nosed over.Apr 21, 1984 · N8092C · Substantial damage NTSB ATL83LA017Accident · No injuriesLimited investigationFinal reportCessna 170A · Youngsville, NCWhile landing, the pilot touched down fast after crossing over power lines near approach end of the runway. He used the brakes to slow down, but was unaware that the wheels were skidding on the grass until the plane came to a bare patch of ground. According…Oct 27, 1982 · N11576 · Substantial damage