Skip to content

NTSB investigations

3,083 cases where the first occurrence was “Hard landing”.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

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."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.\"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."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 FTW92LA228Accident · No injuriesLimited investigationFinal reportFairchild SA-227-AC · San Antonio, TXThe landing capability of the airplane was exceeded. The lack of performance data was a factor in the accident.Sep 18, 1992 · N2183A · Substantial damage NTSB BFO92LA146Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Middle Bass, OHInadequate flare which resulted in a hard landing.Sep 17, 1992 · N7427J · Substantial damage NTSB CHI92LA278Accident · No injuriesLimited investigationFinal reportCessna 172P · Yipslanti, MIThe pilot's premature flare during landing and not performing a recovery from a bounced landing.Sep 15, 1992 · N96593 · Substantial damage NTSB BFO92LA139Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Shelbyville, KYAn improper flare made by the pilot resulting in a hard landing and main rotor blade tail boom strike.Sep 13, 1992 · N950SC · Substantial damage NTSB BFO92LA138Accident · No injuriesLimited investigationFinal reportPiper PA 22-150 · Greenville, METhe pilot's inadequate flare resulting in a hard landing.Sep 13, 1992 · N4319A · Substantial damage NTSB LAX92LA383Accident · No injuriesLimited investigationFinal reportHughes 269C · Rialto, CAThe pilot/passenger's failure to maintain adequate rotor RPM and the pilot-in-command's inadequate supervision of the flight.Sep 12, 1992 · N58164 · Substantial damage NTSB LAX92LA376Accident · No injuriesLimited investigationFinal reportCessna 205A · Gerlach, NVThe pilot misjudged the landing flare and failed to properly recover from the bounced landing.Sep 6, 1992 · N4825U · Substantial damage NTSB LAX92LA372Accident · No injuriesLimited investigationFinal reportMaule M5-180C · San Jose, CAThe pilot's misjudged landing flare which resulted in a bounced landing and the pilot's improper recovery from the bounced landing.Sep 1, 1992 · N8070 · Substantial damage NTSB ATL92LA168Accident · No injuriesLimited investigationFinal reportBeech C23 · Pageland, SCThe pilot's improper touchdown, resulting in an overload failure of the nose gear attachment support tubes. Factors were the lack of total experience of the pilot and the ditch adjacent to the runway.Aug 28, 1992 · N63892 · Substantial damage NTSB LAX92LA362Accident · No injuriesLimited investigationFinal reportEnstrom F28C · Irwindale, CAThe pilot's misjudgment of the landing flare during a practice autorotation.Aug 20, 1992 · N595H · Substantial damage NTSB ATL92LA163Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Oviedo, FLThe failure of the dual student to properly flare the aircraft during the landing attempt, and the flight instructor's failure to perform remedial action to prevent the hard landing.Aug 20, 1992 · N2662R · Substantial damage NTSB CHI92LA252Accident · Serious injuriesLimited investigationFinal reportCameron N-90 · Centralia, ILAbrupt touchdown.Aug 16, 1992 · N75250 · No damage NTSB CHI92LA244Accident · No injuriesLimited investigationFinal reportBeech 19A · Park Rapids, MNA hard landing due to excessive descent rate.Aug 16, 1992 · N6055N · Substantial damage NTSB ANC92LA128Accident · Minor injuriesLimited investigationFinal reportDe Havilland DHC-2 · Crescent Lake, AKThe pilot's misjudging his altitude on final approach. Contributing to the accident was the glassy water condition.Aug 12, 1992 · N8190Y · Substantial damage NTSB NYC92LA155Accident · No injuriesLimited investigationFinal reportBroussard MH-1521M · Elyria, OHThe pilot's improper flare resulting in a hard bounced landing and subsequent blown tire and loss of airplane control.Aug 9, 1992 · N239HL · Substantial damage NTSB NYC92LA144Accident · Minor injuriesLimited investigationFinal reportJohn Mitchell Myers Special · Franklin, PAThe pilot inadvertently porpoised the airplane during the landing and improper recovery from a bounced landing. A factor in this accident was the pilot's lack of experience in this type of aircraft.Aug 7, 1992 · N163JM · Destroyed NTSB NYC92LA146Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Farmington, MDThe pilot's improper level off which resulted in a hard landing. Contributing was an inadeuate recovery from a bounced landing, and the pilot's lack of total flight experience.Aug 6, 1992 · N5633E · Substantial damage NTSB ATL92LA149Accident · No injuriesLimited investigationFinal reportCessna 182A · Aiken, SCThe pilot's diverted attention which resulted in the improper use of the elevator and inadvertent porpoise.Aug 1, 1992 · N5532B · Substantial damage NTSB LAX92LA326Accident · No injuriesLimited investigationFinal reportHughes 369D · Honolulu, HIThe student's improper use of the flight controls during an attempted recovery from an over rotation during the flare, and, the flight instructor's inadequate supervision of the flight.Jul 31, 1992 · N64MK · Substantial damage NTSB SEA92LA177Accident · No injuriesLimited investigationFinal reportCessna 182Q · Afton, WYThe premature landing flare by the pilot.Jul 29, 1992 · N4906N · Substantial damage NTSB SEA92LA165Accident · No injuriesLimited investigationFinal reportPiper PA-24-260 · Spokane, WAThe premature landing flare by the recently certificated private pilot, and her failure to properly recover from the bounced landing. A factor relating to the accident was the gusty wind conditions.Jul 26, 1992 · N139CA · Substantial damage NTSB BFO92LA116Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Spencerport, NYThe pilot's inadequate flare which resulted in a hard landing.Jul 26, 1992 · N4389X · Substantial damage NTSB LAX92LA315Accident · No injuriesLimited investigationFinal reportRobinson R-22B · Carlsbad, CAThe student pilot's failure to maintain adequate rotor RPM during a simulated engine failure, and the flight instructor's inadequate supervision of the flight.Jul 25, 1992 · N2335Q · Substantial damage NTSB LAX92LA302Accident · Serious injuriesLimited investigationFinal reportCessna 180H · Ukiah, CAThe pilot's failure to maintain directional control of the aircraft during the aborted landing and initial climb-out. The pilot's improper landing flare, the inadvertent porpoise, and his improper recovery from a bounced landing were factors in the accident.Jul 18, 1992 · N2499F · Substantial damage NTSB LAX92LA291Accident · No injuriesLimited investigationFinal reportCessna 210 · Truckee, CAThe pilot's improper flare.Jul 8, 1992 · N9652T · Substantial damage NTSB FTW92LA175Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Granbury, TXThe pilot's improper flare during landing and his improper recovery from a bounced landing.Jul 8, 1992 · N4046R · Substantial damage NTSB FTW92LA171Accident · No injuriesLimited investigationFinal reportCessna R172K · Eufaula, OKThe pilot's inadequate compensation for the wind conditions. The turbulent winds near the end of the runway were a factor in the accident.Jun 30, 1992 · N7319K · Substantial damage NTSB CHI92LA191Accident · No injuriesLimited investigationFinal reportCessna 152 · East Tawas, MIThe pilot's failure to adequately compensate for the wind conditions and failure to properly flare the airplane. Contributing to the accident was the crosswind condition.Jun 28, 1992 · N714WT · Substantial damage NTSB NYC92LA130Accident · No injuriesLimited investigationFinal reportCessna 152 · Durhamville, NYThe pilot's improper recovery from a bounced landing which resulted in collapsing of the nose gear. Factor related to the accident was the pilot misjudged the flare/touchdown.Jun 26, 1992 · N69005 · Substantial damage NTSB LAX92LA265Accident · No injuriesLimited investigationFinal reportCessna 172N · Hayward, CAThe student pilot's misjudging the landing flare, the cfi's delayed remedial action and his failure to adequately supervise the conduct of the flight.Jun 26, 1992 · N9447E · Substantial damage NTSB SEA92LA133Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Blakely Island, WAThe pilot in command's not maintaining the proper rate of descent and not maintaining directional control, and separation of the nose gear strut and overload of the right main gear strut. Factors contributing to the accident were: weather conditions: tailwind…Jun 23, 1992 · N5794Q · Substantial damage NTSB LAX92LA250Accident · No injuriesLimited investigationFinal reportBeech A-23 · Willows, CAThe pilot's poorly planned approach. Contributing to this accident was the pilot misjudged the flare altitude and failed to maintain the proper airspeed.Jun 16, 1992 · N1482L · Substantial damage NTSB ATL92LA125Accident · No injuriesLimited investigationFinal reportCessna 172 · Auburn, ALThe pilot's improper landing flare, and his improper recovery from a bounced landing.Jun 14, 1992 · N97883 · Substantial damage NTSB NYC92LA125Accident · Minor injuriesLimited investigationFinal reportBeech 33A · Farmingdale, NJThe pilot's improper recovery from a bounced landing which resulted in collapsing of the nose gear. A factor in the accident was gusting cross winds.Jun 13, 1992 · N17818 · Substantial damage NTSB FTW92GA160Accident · No injuriesFinal reportMcdonnell Douglas 369E · Yukon, OKThe dual student's failure to maintain adequate main rotor RPM and failure to level the helicopter at touchdown. Factors were the manufacturer's training pilot's inadequate supervision and the dual student performing the maneuver.Jun 13, 1992 · N684F · Substantial damage NTSB ATL92LA123Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Winnsboro, SCThe pilot's improper level off and his improper recovery from a bounced landing.Jun 13, 1992 · N2106E · Substantial damage NTSB NYC92LA106Accident · Minor injuriesLimited investigationFinal reportGlasair SH-2 · Danbury, CTImproper recovery from a bounced landing by the pilot which resulted in a propeller strike which made further flight not possible.Jun 10, 1992 · N155JL · Substantial damage NTSB SEA92LA123Accident · Minor injuriesLimited investigationFinal reportCessna TR182 · Baker, ORThe pilots inadequate recovery from a bounced landing. Factors include unfavorable, gusty winds.Jun 9, 1992 · N6138S · Substantial damage NTSB FTW92LA154Accident · No injuriesLimited investigationFinal reportBeech 76 · Sherman, TXThe instructor pilot's delayed remedial action, improper configuration, and inadvertent stall.Jun 8, 1992 · N6003V · Substantial damage NTSB LAX92LA238Accident · No injuriesLimited investigationFinal reportCessna 177A · Mariposa, CAThe pilot's poorly planned approach for landing, his failure to initiate a go-around, his failure to obtain the proper touchdown point, his misjudgment of the touchdown flare, and his improper recovery from a bounced landing. A factor in this accident was the…Jun 7, 1992 · N3144T · Substantial damage NTSB CHI92DEV02Accident · Minor injuriesFinal reportSchweitzer Mustang II · Decatur, ILThe pilot's delay in initiating a go-around.May 25, 1992 · N91ES · Substantial damage NTSB BFO92LA082Accident · Serious injuriesLimited investigationFinal reportAerostar AX-9 - S-66A · Southhampton, NJThe pilot used an excessive descent rate during landing. Contributing to the accident was an unfavorable wind condition.May 24, 1992 · N3604Y · No damage NTSB SEA92LA107Accident · Serious injuriesLimited investigationFinal reportDonald E. Crocker RV-6 · Vancouver, WAAn improper recovery from a bounced landing which resulted in an aerodynamics stall.May 23, 1992 · N116DC · Substantial damage NTSB CHI92LA157Accident · No injuriesLimited investigationFinal reportCessna 150 · South Bend, INImproper aircraft control by the pilot.May 22, 1992 · N6349G · Substantial damage NTSB BFO92LA071Accident · Minor injuriesLimited investigationFinal reportCessna U206E · Turner, METhe pilot's inadequate flare which resulted in a hard landing. Contributing to the accident was the soft terrain.May 21, 1992 · N9446G · Substantial damage NTSB MIA92LA123Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Fort Lauderdale, FLDelay by the CFI to take remedial action. Contributing to the accident was the students premature flare.May 17, 1992 · N4026Q · Substantial damage NTSB FTW92LA135Accident · No injuriesLimited investigationFinal reportCessna 150M · Stilwell, OKThe pilot inadvertently pushed the nose down during the flare/landing. A factor was the pilot misjudged the flare/landing.May 15, 1992 · N704CJ · Substantial damage NTSB BFO92LA063Accident · No injuriesLimited investigationFinal reportCessna 182M · Vandalia, OHControl interference by a passenger during touchdown.May 13, 1992 · N71879 · Substantial damage NTSB FTW92LA126Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Benton, ARThe pilot's improper recovery from a bounced landing and his improper compensation for crosswind. A factor was the crosswind.May 5, 1992 · N23506 · Destroyed NTSB LAX92FA196Accident · 2 fatalField investigationFinal reportBeech A23-24 · Corona, CA1) The flying pilot's improper landing flare which resulted in a hard landing and significant damage to the aircraft empennage flight controls, 2) the flying pilot's decision to initiate a go around with the obvious serious damage to the aircraft, and 3) the…May 2, 1992 · N666CM · Destroyed