NTSB investigations, LA
25 cases where the first occurrence was “Hard landing”.
Cases per year
| 1984 | 2 |
|---|---|
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 4 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1995 | 2 |
| 1996 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 4 |
| 2004 | 1 |
| 2006 | 1 |
| 2007 | 1 |
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\" = 'LA' 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" = 'LA' 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 DFW07CA201Accident · Serious injuriesData collectionFinal reportUltra Magic M-56C · Bossier City, LAThe pilot's failure to arrest an excessive descent rate prior to ground contact, which resulted in a hard landing.NTSB DFW06CA066Accident · No injuriesData collectionFinal reportRobinson R44 · Rayville, LAThe pilot's failure to maintain rotor RPM, which resulted in a hard landing.NTSB FTW04LA135Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Many, LAThe pilot's improper touchdown which resulted in a hard landing.NTSB FTW02TA007Accident · No injuriesFinal reportCessna A185F · Houma, LAthe pilot's high flare, which resulted in a hard landing.NTSB FTW01LA148Accident · No injuriesLimited investigationFinal reportCessna 152 · Lapace, LAthe student pilot flared the airplane high, which resulted in a hard landing.NTSB FTW01LA145Accident · No injuriesLimited investigationFinal reportCessna 172S · Baton Rouge, LAthe student pilot's improper recovery from a bounced landing.NTSB FTW01LA070Accident · No injuriesLimited investigationFinal reportBartels Rans S-7 · Lafayette, LAthe pilot's improper flare which resulted in a hard landing.NTSB FTW00LA223Accident · No injuriesLimited investigationFinal reportEngineering & Research Ercoupe 415-CD · Abbeville, LAThe pilot's misjudged flare and improper recovery from a bounced landing. A factor was the crosswind condition.NTSB FTW99LA082Accident · No injuriesLimited investigationFinal reportCessna 150M · Baton Rouge, LAThe pilot's failure to maintain an adequate approach airspeed which resulted in a excessive descent rate and hard landing and the pilot's failure to recover from a bounced landing. A factor was the pilot's lack of total experience.NTSB FTW98LA070Accident · Serious injuriesLimited investigationFinal reportCessna 172F · Gonzales, LAThe inadvertent stall resulting from the flight instructor's failure to maintain airspeed during his delayed recovery from the bounced landing. Factors were the student's failure to maintain the proper airspeed and the instructor's inadequate supervision…NTSB FTW96LA277Accident · No injuriesLimited investigationFinal reportCessna 152 · Lake Providence, LAthe pilot's improper flare and improper recovery from a bounced landing, which resulted in an inadvertent porpoise motion of the airplane and subsequent damage.NTSB FTW95LA344Accident · No injuriesLimited investigationFinal reportChampion 7ECA · Monroe, LAThe student pilot's improper flare and the inadequate supervision by the flight instructor.NTSB FTW95LA136Accident · No injuriesLimited investigationFinal reportCessna 152 · New Roads, LAThe pilot's improper bounced landing recovery technique. Factors were his failure to execute a go-around, his improper landing flare, and the other pilot's premature taxiing onto the runway for takeoff.NTSB FTW93LA046Accident · No injuriesLimited investigationFinal reportCessna 152 · New Orleans, LAHard landing due to the pilot's inadequate flare. A factor was the blocked rudder.NTSB FTW91LA097Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · New Orleans, LAThe pilot's improper recovery from a bounced landing. A factor was: the pilot's lack of total experience in model.NTSB FTW90DRD06Accident · Serious injuriesFinal reportStolt Acroduster II · Alexandria, LAThe pilot misjudged the landing flare.NTSB FTW90DRD01Accident · No injuriesFinal reportLong E-Z-E Long E-Z-E- · Hammond, LAInadequate aircraft handling and recovery from a bounced landing. Factors were gusty wind conditions, the pilot's failure to maintain directional control, and the pilot's lack of familiarity with the airplane.NTSB FTW90LA003Accident · No injuriesLimited investigationFinal reportAerospatiale 350D · New Iberia, LAThe second pilot's (under instruction) misjudgement of aircraft attitude during the level off phase of the autorotationNTSB FTW89LA153Accident · Serious injuriesLimited investigationFinal reportCessna 150C · Jonesboro, LAThe pilot's improper flare, improper recovery from a bounced landing, and failure to maintain directional control, which resulted in a porpoise off the side of the runway. The tree was a related factor.NTSB FTW89LA150Accident · No injuriesLimited investigationFinal reportBell 206B · Oak Grove, LAPilot's improper emergency procedures and flare that led to a hard landing and roll over. Factors in the accident were the pilot's decision to initiate an autorotation following an undetermined event and failure to maintain directional control during the…NTSB FTW87LA110Accident · No injuriesLimited investigationFinal reportLaw OSPREY-2 · Minden, LAPilot stated that he flared about ten feet too high and landed hard collapsing the main gear followed by the aircraft sliding off the runway and colliding with a ditch where substantial damage occurred.NTSB FTW86LRD07Accident · No injuriesFinal reportMBB BO-105-CBS · Lake Charles, LAThe helicopter was simulating a single eng landing on an area marked to the size of an offshore helideck. The acft touched down hard enough to attract the attention of several witnesses. The crew continued with the training but later on post flt exam they…NTSB FTW85FA282Accident · 1 fatalField investigationFinal reportAerospatiale AS-350D · Matagorda Islng, LAThe acft touched down hard during an attempted autorotation to an abandoned air base. Initial touchdown occurred on the stinger and the acft yawed to the left of rwy heading 30 to 40 degrees. The next touchdown was on the skids and the acft yawed further to…NTSB FTW85LA036Accident · No injuriesLimited investigationFinal reportRobinson R22 · New Orleans, LAAccording to the CFI there was no intention to perform 'touchdown' autorotation landings. During the third simulated power loss the CFI reported that he initiated the flare at about 55 ft AGL. As airspeed dissipated and the sink rate continued the CFI…NTSB FTW84LA390Accident · No injuriesLimited investigationFinal reportFairchild M-62A (PT-19) · Melville, LAThe student plt stated that the acft touched down long and bounced. He applied power to go-around and lost directional control colliding with a fence on the left side of the rwy. The wind was clam.