Skip to content

NTSB investigations, NE

24 cases where the first occurrence was “Hard landing”.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19832026

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

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\" = 'NE' 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" = 'NE' 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 CHI05CA232Accident · No injuriesData collectionFinal reportLet Blanik L-13 · Blair, NEThe low airspeed by the pilot and the inadequate supervision by the certified flight instructor.Aug 6, 2005 · N9295Z · Substantial damage NTSB CHI04CA093Accident · No injuriesData collectionFinal reportBeech F33A · Wahoo, NEThe pilot's improper recovery from the bounced landing resulting in the collapse of the nose landing gear. A factor was the pilot's misjudged landing flare.Mar 21, 2004 · N3077H · Substantial damage NTSB CHI00LA217Accident · No injuriesLimited investigationFinal reportCessna 182S · Millard, NEthe improper recovery from the bounced landing and the porpoise encountered by the pilot. Factors were the misjudged flare by the pilot and the runway light.Jul 22, 2000 · N7278S · Substantial damage NTSB CHI00LA197Accident · No injuriesLimited investigationFinal reportCessna 152 · Lincoln, NEthe misjudged flare and the inadequate recovery from the bounced landing performed by the student pilot.Jul 2, 2000 · N6432M · Substantial damage NTSB CHI99LA304Accident · No injuriesLimited investigationFinal reportCessna 152 · Omaha, NEthe student pilot's improper use of elevator control during the landing roll.Aug 18, 1999 · N869NE · Substantial damage NTSB CHI99LA148Accident · No injuriesLimited investigationFinal reportCessna 172 · Blair, NEThe pilot's misjudged landing flare.Apr 29, 1999 · N5336R · Substantial damage NTSB CHI99LA035Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Alliance, NEWas the late flare and stall by the student pilot and improper remedial actions by the student pilot.Nov 23, 1998 · N22269 · Destroyed NTSB CHI99LA030Accident · No injuriesLimited investigationFinal reportCessna 172C · Falls City, NEthe flight instructor (on the ground)'s conducting inadequate initial training of the student pilot. Factors were the student pilot's misjudging the flare and his lack of total experience in the type of operation.Nov 14, 1998 · N1806Y · Substantial damage NTSB CHI98LA084Accident · No injuriesLimited investigationFinal reportCessna 208B · Grand Island, NEice build-up on the airplane's wings and empennage which led to an inadvertent stall and hard landing. Factors contributing to this accident were the pilot's inadvertent flight into icing conditions, and the icing conditions.Jan 20, 1998 · N738FX · Substantial damage NTSB CHI95LA089Accident · No injuriesLimited investigationFinal reportCessna T310R · Grand Island, NEthe pilot's failure to deploy the deicing boots during the approach and the failure to maintain aircraft control during the landing. A factor related to the accident was the existing icing conditions.Feb 15, 1995 · N4092C · Substantial damage NTSB CHI92LA293Accident · Serious injuriesLimited investigationFinal reportCameron O-77 · North Omaha, NEThe pilot's abrupt touchdown during a balloon landing. A related factor is the unsuitable terrain selected.Sep 27, 1992 · N9539G · No damage NTSB CHI92LA135Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Sidney, NEWas an inadvertent stall/mush during landing by the pilot. A factor related to the accident was lack of recent total experience.Apr 26, 1992 · N3811W · Substantial damage NTSB CHI91LA119Accident · No injuriesLimited investigationFinal reportCessna 182P · Loup City, NEThe pilot's improper landing/touchdown. A related factor was the pilot's lack of total flight experience.Mar 21, 1991 · N91376 · Substantial damage NTSB CHI91LA034Accident · No injuriesLimited investigationFinal reportCessna 401 · Grand Island, NEFlight into known adverse weather conditions and flare misjudged. Factors related to the accident were: icing conditions resulting in reduced aircraft controllability and restricted visual outlook.Nov 27, 1990 · N10QP · Substantial damage NTSB DEN90LA090Accident · No injuriesLimited investigationFinal reportCessna 172 · Ogallala, NEThe misjudged landing flare. A factor was the pilot's lack of experience.Apr 7, 1990 · N64739 · Substantial damage NTSB MKC88LA078Accident · No injuriesLimited investigationFinal reportPiper PA-25 · Red Cloud, NEAfter a first time familiarization flt, the pilot returned to the base field for ldg. During the landing attempt, the aircraft bounced, and on recovery, the pilot pitched the nose up too high. The aircraft stalled and then struck the runway damaging the…Apr 16, 1988 · N7071Z · Substantial damage NTSB MKC86LA092Accident · No injuriesLimited investigationFinal reportCessna 172P · Omaha, NEThe plt stated he was attempting a night landing but after repeated trys he requested assistance on the radio. The plt further stated that the inoperative landing light compounded the trouble and he made a hard three point landing. Subsequent inspection of…Apr 12, 1986 · N63177 · Substantial damage NTSB MKC85FCJ01Accident · Serious injuriesFinal reportRobinson R22 · Gladstone, NEThe acft made a hard off arpt landing in an unlighted farm field on a dark night. The acft'dropped in' from about 50 ft AGL in a vertical descent. After ground contact the acft rolled over to the right. No mechanical malfunctions were noted during the…May 20, 1985 · N8386B · Destroyed NTSB MKC85LA010Accident · No injuriesLimited investigationFinal reportAspen Quickie 2 · Grand Island, NEThe plt stated that he was practicing landings & had less than three hours total time in the Q2. He said he flared high & bounced three times. During the third bounce the front wing, to which the main landing gear is attached, broke & the acft ran off the…Oct 29, 1984 · N39202 · Substantial damage NTSB MKC84LA167Accident · No injuriesLimited investigationFinal reportCessna 172P · Fremont, NEThe pilot selected a downwind rwy for landing. Touchdown was nose gear first, followed by a porpoise and a go-around. On the second approach to the same runway, touchdown was again nose first and the aircraft porpoised twice before landing was completed. The…Jun 8, 1984 · N97163 · Substantial damage NTSB MKC84LA099Accident · No injuriesLimited investigationFinal reportCessna 182J · Minden, NEThe plt had returned from dropping skydivers & was landing on rwy 29 at sunset. He reported that during the flare to land, he was temporarily blinded by the sun. The acft landed hard & bounced back into the air. It then settled, veered off the rwy, hit piles…Mar 14, 1984 · N2832F · Substantial damage NTSB MKC84LA022Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-3 · Millard, NEDuring arrival from vfr-on-top, the plt was given radar vectors for the NDB apch. The plt stated that he was in the clouds during the apch for only about 5 to 8 min. He reported that aprx 1/2 mi out on final apch, the nose became progressively heavy and the…Nov 16, 1983 · N8229A · Substantial damage NTSB MKC83LA168Accident · No injuriesLimited investigationFinal reportBeech A100 · Valley, NEWhile landing at night, the acft touched down hard, then swerved off the left side of the rwy. An exam of the acft revealed that the left landing gear down plate, pn 99810022, had failed. An exam of the plate revealed that it had failed from overload.Aug 1, 1983 · N17CP · Substantial damage NTSB MKC83LA070Accident · No injuriesLimited investigationFinal reportCessna 140 · Scottsbluff, NEThe aircraft made a hard landing while landing at Scottsbluff NE during a pleasure flight. The aircraft was landing on runway 30 with the wind from 350 degrees at 8 KTS. A witness said the aircraft bounced 2 times before groundlooping off the left side of the…Feb 20, 1983 · N1798V · Substantial damage