NTSB investigations, NC
59 cases where the first occurrence was “Hard landing”.
Cases per year
| 1982 | 4 |
|---|---|
| 1983 | 2 |
| 1984 | 6 |
| 1985 | 1 |
| 1986 | 4 |
| 1987 | 1 |
| 1988 | 2 |
| 1989 | 2 |
| 1990 | 2 |
| 1991 | 3 |
| 1992 | 1 |
| 1993 | 1 |
| 1995 | 2 |
| 1996 | 3 |
| 1997 | 1 |
| 1998 | 1 |
| 2000 | 2 |
| 2001 | 2 |
| 2002 | 3 |
| 2003 | 4 |
| 2004 | 1 |
| 2005 | 5 |
| 2006 | 2 |
| 2007 | 4 |
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\" = '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\" = 200)
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" = 200) 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 NYC07CA195Accident · No injuriesData collectionFinal reportCessna 172L · Winston-Salem, NCThe pilot's improper recovery from a bounced landing.NTSB NYC07CA131Accident · No injuriesData collectionFinal reportCessna 172S · Raleigh-Durham, NCThe pilot's improper recovery from a bounced landing.NTSB MIA07CA101Accident · No injuriesData collectionFinal reportMooney M20R · Carthage, NCThe delay by the pilot-in-command to recover from a bounced landing resulting in a hard landing and subsequent collapse of the nose and left main landing gears.NTSB NYC07CA116Accident · No injuriesData collectionFinal reportCessna 172S · Asheville, NCThe pilot's improper landing flare which resulted in a hard landing. A factor in the accident was the visual illusion experienced by the pilot from landing on a long, wide runway.NTSB ATL06CA095Accident · No injuriesData collectionFinal reportFantasy Air Allegro 2000 · Sanford, NCThe student pilot's improper flare, and inadequate recovery from a bounced landing.NTSB ATL06CA062Accident · No injuriesData collectionFinal reportCessna C-172S · Sanford, NCThe pilot's improper landing flare which resulted in a hard landing.NTSB ATL06CA047Accident · No injuriesData collectionFinal reportCessna 172 P · Wilmington, NCThe student pilot's improper landing flare which resulted in a hard landing.NTSB ATL06CA018Accident · No injuriesData collectionFinal reportCessna 152 · Durham, NCThe pilot's improper flare on landing flare touchdown resulting in a hard landing and collapse of the nose gear.NTSB ATL05CA160Accident · No injuriesData collectionFinal reportCessna 182T · Wilmington, NCThe pilot's improper flare which resulted in a hard landing, and the collapse of the nose gear.NTSB ATL05CA134Accident · No injuriesData collectionFinal reportAircraft Mfg & Dev. CH2000 · Winston-Salem, NCThe student pilot's misjudged flare and his improper recovery from a bounced landing resulting in a stall and hard landing.NTSB ATL05CA093Accident · No injuriesData collectionFinal reportAllegro 2000 · Leasburg, NCThe pilot's inadequate recovery from a bounced landing, resulting in a hard landing, and the subsequent on ground collision with trees.NTSB ATL05CA021Accident · No injuriesData collectionFinal reportCessna 152 · Rocky Mount, NCThe pilot's improper landing flare, and improper recovery from a bounced landing.NTSB ATL04LA059Accident · No injuriesLimited investigationFinal reportSocata TB21 · Spruce Pine, NCThe pilot's inadequate flare, and his failure to maintain directional control. The pilot's improper recovery from a bounced landing, and trees are a contributing factor.NTSB ATL04LA031Accident · No injuriesLimited investigationFinal reportCessna 172R · New Bern, NCThe student pilot's improper landing flare resulting in a hard landing.NTSB ATL03LA119Accident · No injuriesLimited investigationFinal reportCessna 182J · Southern Pines, NCThe pilot's improper landing flare which resulted in a hard landing.NTSB ATL03LA060Accident · No injuriesLimited investigationFinal reportCessna 172P · Concord, NCThe pilot's improper flare during touchdown and failure to properly recover from a bounced landing, which resulted in a loss of control and inflight collision with the runway. A factor was the pilot did not understand the porpoise condition during landing.NTSB MIA02CA177Accident · No injuriesData collectionFinal reportAviat A-1 · Cherry Point, NCthe pilot misjudged the landing flare, resulting in a hard landing, an inadvertent ground loop, and the subsequent impact with the runway.NTSB MIA02LA157Accident · No injuriesLimited investigationFinal reportCessna 172N · Pinehurst, NCThe student pilot's improper recovery from bounced landing which resulted in substantial damage to the airplane.NTSB ATL02LA132Accident · No injuriesLimited investigationFinal reportCessna 182 · Saint Pauls, NCThe pilots improper flare, during an attempted landing.NTSB ATL02LA006Accident · No injuriesLimited investigationFinal reportBeech BE-55-T42A · Raleigh, NCThe pilot's improper flare, and improper recovery from a bounced landing.NTSB MIA02LA005Accident · No injuriesLimited investigationFinal reportCessna 152 · Greenville, NCThe improper flare by the pilot-in-command resulting in a hard landing and subsequent collapse of the nose landing gear due to overload.NTSB MIA00LA214Accident · No injuriesLimited investigationFinal reportCessna 172L · Beaufort, NCThe failure of the pilot to initiate a go-around after the airplane began to porpoise, resulting in a hard landing and structural damage to the airplane.NTSB MIA00LA085Accident · No injuriesLimited investigationFinal reportCessna 152 · Louisburg, NCThe improper recovery from the bounced landing by the pilot-in-command for his failure to apply power and inadvertent stall by the pilot-in-command resulting in a hard landing. A contributing factor was the total lack of experience of the pilot-in-command.NTSB ATL99LA018Accident · No injuriesLimited investigationFinal reportCessna 182Q · Hickory, NCThe pilot's failure to properly recover from a bounced landing.NTSB ATL97LA058Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Southern Pines, NCthe student pilot's improper landing flare and the flight instructor's inadequate supervision of the training flight, which led to a hard landing.NTSB MIA96LA196Accident · No injuriesLimited investigationFinal reportCessna 150M · Knightdale, NCthe student pilot's improper recovery from a bounced landing by applying power and slight nose up elevator input.NTSB ATL96LA086Accident · No injuriesLimited investigationFinal reportCessna 172 · Winston-Salem, NCThe pilot's improper use of the elevator in response to a bounced landing.NTSB MIA96FA082Accident · 2 fatalField investigationFinal reportBeech 95-B55 · Morganton, NCthe pilot's delay in initiating a go-around (aborted landing), which resulted in his failure to obtain/maintain sufficient altitude or clearance from trees beyond the end of the runway. Factors relating to the accident were: the pilot's failure to ensure…NTSB MIA96LA015Accident · No injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Morganton, NCThe pilot-in-command's excessive rate of descent on short final.NTSB ATL95LA096Accident · No injuriesLimited investigationFinal reportCessna 150M · Indian Trail, NCThe pilot's improper landing flare and improper recovery from a bounced landing.NTSB ATL93LA140Accident · No injuriesLimited investigationFinal reportCessna 172M · Manteo, NCInadequate compensation for wind conditions by the pilot. Factors related to the accident were: the adverse wind and the pilot's failure to obtain a weather briefing (inadequate weather evaluation).NTSB ATL92LA055Accident · No injuriesLimited investigationFinal reportPitts S-1 · Reidsville, NCThe pilot's failure to compensate for the tailwind and the improper touch down point. Factors were the tailwind and downdraft which resulted from the tall obstacles (trees) around the runway.NTSB ATL91LA147Accident · No injuriesLimited investigationFinal reportCessna 150J · Greensboro, NCThe pilot's improper flare during the landing. Factors in the accident were the dark night and lack of runway edge lights.NTSB ATL91LA082Accident · No injuriesLimited investigationFinal reportCessna 172P · Hatteras, NCThe pilot's improper landing flare, subsequent inadvertent porpoise, and his failure to execute a bounced landing recovery.NTSB ATL91LA056Accident · No injuriesLimited investigationFinal reportErcoupe 415C · Gastonia, NCThe pilot's improper flare and subsequent failure to recover from a bounced landing.NTSB ATL91LA012Accident · No injuriesLimited investigationFinal reportCessna 150M · Williamston, NCThe student pilot's failure to properly flare the airplane during the night landing attempt. The pilot's failure to maintain geographic orientation and the subsequent flight into night conditions were factors in the accident. The pilot's lack of night flying…NTSB ATL90LA164Accident · No injuriesLimited investigationFinal reportCessna 182N · Knightdale, NCThe failure of the pilot to execute timely go around procedures. The pilot's lack of experience in this make and model of airplane were factors in the accident.NTSB ATL89DMG04Accident · No injuriesFinal reportWittman, S.J. W-8 · Washington, NCPilot inadvertently stalled the airplane.NTSB ATL89LA147Accident · No injuriesLimited investigationFinal reportCessna 172N · Fuquay, NCFailure of the student pilot to maintain directional control of the aircraft during the landing, which resulted in an inadvertent ground swerve. Contributing factors were: improper flare by the student during the landing, which resulted in a hard landing, and…NTSB ATL89LA011Accident · Minor injuriesLimited investigationFinal reportCessna 177B · Hatteras, NCThe plt reported that he initially flared too high during the landing. He recovered and the acft subsequently touched down 'firmly' on the main gear. The acft then began to veer to the rt 'as if the rt brake was locked'. The plt attempted to abort the ldg &…NTSB ATL88LA214Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Andrews, NCThe pilot failed to establish a proper apch profile and experienced a hard landing. The hard landing caused the main landing gear to collapse, and the airplane veered off of the left side of the runway. A witness located near the runway confirmed that the…NTSB ATL87LA264Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Winston Salem, NCThe student pilot was performing touch and go landings as part of his supervised solo training. The aircraft landed hard and bounced twice before coming to rest with a collapsed nose gear. Examination of the airframe disclosed extensive crushing damage to the…NTSB DCA86IA001Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-9-51 · Raleigh-Durham, NCDrg arrival, the flt crew made a visual apch to rwy 23L in calm wind conds. Flt crew statements indicated that when they were on final apch at about 100 ft AGL, the acft was on the proper glidepath for landing. However the resulting grnd contact was harder…NTSB ATL86LA241Accident · No injuriesLimited investigationFinal reportCessna 150 · Smithfield, NCThe pilot reported that during a practice landing he flared too high off the runway surface. The pilot lowered the nose, causing the nosewheel to strike the runway. The pilot lost control and the acft skidded off the left side, down an embankment and flipped…NTSB ATL86LA214Accident · Minor injuriesLimited investigationFinal reportCessna 150F · Lenoir, NCThe student plt was executing full stop landings then making a take off after each landing. He was attempting his fourth landing when the acft bounced, he applied power to try to regain control of the acft. The nose gear collapsed upon touch down, the strut…NTSB ATL86FMG05Accident · No injuriesFinal reportCessna 150 · Yadkinville, NCThe acft was landed improperly and after bouncing two of three times the nose gear separated. The acft then nosed over and suffered further damage to the prop, wings and tail.NTSB ATL85LA190Accident · No injuriesLimited investigationFinal reportBeech C-23 · Wilmington, NCThe student plt was making a landing at the second arpt of a x-country flt when a controller in the tower observed the acft bounce and spotted the nose gear lying on the rwy. An ELT signal was also received at that time. The student plt made a go-around and…NTSB ATL85LA059Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA341G · Cornelius, NCWith the executive vice president of the company acting as PIC and the company plt acting as co-plt, the acft approcahed the operator's slightly elevated helipad. According to pax statements, the acft landed hard, bounced into the air and began spinning…NTSB ATL85LA015Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Charlotte, NCDuring attempted go-around from a bounced landing, the plt allowed the acft to drift off center line and into trees paralling the runway. Directional control was compromised by low flying speed.NTSB ATL84LA267Accident · No injuriesLimited investigationFinal reportCessna 172M · Winston-Salem, NCFollowing a high and slow apch, the plt decided to discontinue the landing. Power was added for a go-around, but the power response was not sufficient and the plt elected to continue the landing. Power was reduced and the nose lowered but, the acft stalled…