NTSB investigations
6,629 cases where the first occurrence was “Loss of control - on ground/water”.
Cases, newest first
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.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260) 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" = 260) 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 NYC94LA177Accident · No injuriesLimited investigationFinal reportCessna 195 B · Richmond, VAThe pilot's failure to maintain directional control which resulted in a ground loop. Contributing factors are excessive airspeed, fatigue, and improper recovery from a bounced landing.NTSB ANC94LA134Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Gulkana, AKThe failure of the pilot to compensate for a tailwind and maintain directional control of the airplane. A tailwind was a factor in the accident.NTSB FTW94LA294Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Englewood, COThe pilot's inadvertent groundloop of the airplane.NTSB ANC94LA132Accident · No injuriesLimited investigationFinal reportJames Chisum CHISUM-SCRAPS · Fairbanks, AKThe failure of the pilot to maintain directional control of the airplane. Factors in the accident were the soft terrain and inadequate remedial action.NTSB LAX94LA369Accident · No injuriesLimited investigationFinal reportCessna T210L · Kettleman City, CAThe pilot's selection of the wrong runway for takeoff and his failure to maintain runway alignment. The sun glare was a factor in this accident.NTSB FTW94LA286Accident · No injuriesLimited investigationFinal reportCessna 150M · Mesquite, TXThe unfavorable gusting winds. A factor was the pilot's failure to maintain directional control.NTSB NYC94LA163Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Vine Grove, KYThe pilot's (1) inadequate compensation for wind conditions and (2) failure to align with the runway during landing touch down.NTSB SEA94LA227Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Everett, WAThe pilot failed to maintain directional control.NTSB LAX94LA344Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Five Points, CAthe pilot's inadequate compensation for the existing crosswind condition and his failure to maintain the proper runway alignment.NTSB ATL94LA168Accident · No injuriesLimited investigationFinal reportCessna 152 · Headland, ALThe failure of the student pilot to maintain control of the aircraft during a crosswind landing.NTSB SEA94LA226Accident · No injuriesLimited investigationFinal reportCessna 182P · Yamhill, ORThe pilot's failure to maintain directional control. A factor to the accident was: an inadequate recovery from a bounced landing.NTSB BFO94LA157Accident · No injuriesLimited investigationFinal reportBeech A-23 · Felton, DEThe pilot's improper recovery from a bounced landing and failure to maintain directional control. A factor is the pilot's failure to do a go around.NTSB LAX94LA339Accident · No injuriesLimited investigationFinal reportCessna 172 · Lakeport, CAThe pilot's inadequate compensation for the existing cross wind conditions, and failure to maintain directional control of the airplane during landing rollout.NTSB BFO94LA151Accident · Minor injuriesLimited investigationFinal reportGrumman G-44 · Nantucket, MAThe pilot's failure to maintain aircraft control. A factor in the accident was the rough water.NTSB SEA94LA220Accident · No injuriesLimited investigationFinal reportBeech 23 · Everett, WAThe student pilot's failure to maintain directional control, and his inadequate remedial action. Factors include a fence in the vicinity of the runway.NTSB SEA94LA219Accident · No injuriesLimited investigationFinal reportCessna 150E · Mcminnville, ORThe student pilot's failure to maintain directional control, and his inadequate remedial action. Factors include soft terrain in the vicinity of the runway.NTSB CHI94LA296Accident · No injuriesLimited investigationFinal reportCessna 172 · Anoka, MNthe pilots decision to attempt a landing ahead of the approaching thunderstorm, and his failure to maintain directional control. A factor was the gusting crosswind ahead of the storm.NTSB LAX94LA334Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Mesa, AZThe student pilot's failure to maintain directional control by his improper use of the flight controls. Factors related to this accident were the pilot's lack of total experience and the crosswind.NTSB MIA94LA198Accident · No injuriesLimited investigationFinal reportCessna 152 · Arcadia, FLThe pilot's inadequate compensation for wind conditions. The gusty, crosswind was a factor.NTSB SEA94LA215Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Hailey, IDThe pilot's inadequate compensation for wind conditions. A factor to the accident was a tailwind.NTSB SEA94LA214Accident · No injuriesLimited investigationFinal reportCessna 180K · Hite, UTCompensation for wind conditions and weather evaluation were inadequate. Factors to the accident were: crosswind and gusts.NTSB MIA94LA196Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Clearwater, FLThe inadvertent encounter with a water puddle on the runway during takeoff roll which resulted in the pilot losing directional control and running off the side of the runway.NTSB LAX94LA320Accident · No injuriesLimited investigationFinal reportBeech 77 · Salinas, CAthe pilot's failure to raise the flaps prior to takeoff, and subsequent loss of directional control. A lack of total experience was a factor.NTSB LAX94LA319Accident · No injuriesLimited investigationFinal reportPerth Amboy Bird BK · El Cajon, CAThe pilot's inadequate compensation for the wind conditions and his failure to maintain directional control of the aircraft. The unfavorable wind was a factor.NTSB LAX94LA314Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Fresno, CAthe pilot's failure to maintain directional control of the aircraft resulting in a ground loop/swerve and a subsequent overload failure of the right main landing gear.NTSB ATL94LA153Accident · No injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Beaufort, SCThe pilot's improper use of the rudder during landing.NTSB CHI94LA271Accident · Minor injuriesLimited investigationFinal reportPiper PA-34-200 · Marion, IAThe pilot's inadequate aircraft prelight and his failure to remove the frost from the windshield which obstructed his view.NTSB LAX94LA310Accident · No injuriesLimited investigationFinal reportCessna 172M · Carson City, NVthe pilot's decision to attempt a landing in crosswind conditions which exceeded the capability of the aircraft.NTSB ANC94LA099Accident · No injuriesLimited investigationFinal reportCessna 206 · King Salmon, AKThe pilot's failure to use the available longer portion of the lake for the takeoff run.NTSB ANC94LA108Accident · No injuriesLimited investigationFinal reportStinson 108 · Salcha, AKThe pilot did not maintain control of the airplane. A factor in the accident was the pilot's lack of total experience in the specific make/model/type of aircraft.NTSB CHI94LA260Accident · No injuriesLimited investigationFinal reportBoeing A75N1 · Waterford, MIthe failure of the pilot to maintain directional control.NTSB LAX94LA295Accident · No injuriesLimited investigationFinal reportPiper J-3C-65 · Jackson, CAthe pilot's inadequate compensation for the gust of wind and subsequent loss of directional control.NTSB SEA94LA192Accident · No injuriesLimited investigationFinal reportGrumman G-21A · Bremerton, WAThe pilot-in-command's failure to maintain directional control during landing.NTSB SEA94LA193Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Wilder, IDThe failure of the left brake master cylinder and the pilot's inadequate remedial action when the aircraft collided with an embankment during an intentional ground loop.NTSB NYC94LA133Accident · No injuriesLimited investigationFinal reportHoopes RV-6 · Farmingdale, NJThe pilot's improper decision to fly after donating blood which resulted in his incapacitation.NTSB MIA94LA180Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Lutz, FLThe certified flight instructor's improper supervision of the student pilot during a wheel landing resulting in an on ground loss of control (inadvertent ground loop). Contributing to the accident was the student pilot's improper use of flight controls and…NTSB LAX94LA293Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G103 · Tehachapi, CAthe pilot's failure to secure the canopy before takeoff, and his failure to maintain directional control during landing rollout.NTSB ANC94LA086Accident · No injuriesLimited investigationFinal reportCessna 180 · Palmer, AKThe pilot's failure to maintain directional control.NTSB SEA94LA185Accident · No injuriesLimited investigationFinal reportCessna A152 · Bremerton, WAThe pilot's failure to maintain directional control.NTSB SEA94LA180Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Easton, WAThe pilot's failure to maintain directional control. Factors include soft, uneven terrain.NTSB CHI94LA238Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Harvard, ILthe pilot's excessive taxi speed. A factor in the accident was the wet grass runway.NTSB SEA94LA161Accident · No injuriesLimited investigationFinal reportCessna 140 · Kent, WAInadequate compensation for wind conditions. A factor to the accident was wind gust.NTSB NYC94LA118Accident · Minor injuriesLimited investigationFinal reportLuscombe 8F · Leesburg, VAThe pilot's inadequate incompensation for wind conditions resulting in loss of directional control.NTSB SEA94LA173Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Ione, WAThe pilot's failure to maintain directional control. Factors include the pilot's fatigue, and trees near the side of the runway.NTSB CHI94LA223Accident · No injuriesLimited investigationFinal reportPiper PA-25-260 · Crosby, NDthe pilot's failure to maintain directional control during the takeoff roll. Factors associated with the accident are the rough runway, and the pilot's improper preflight planning.NTSB ANC94LA076Accident · No injuriesLimited investigationFinal reportMaule M-4-210 · Northway, AKThe failure of the left main landing gear attachment fittings as a result of the improper welds by the maintenance repair facility. Factors in the accident that precipitated the gear failure were the wind gusts, and the pilot not adequately compensating for…NTSB NYC94LA105Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Put-In-Bay, OHThe pilot's inadequate control and failure to maintain directional control which resulted in collision with a sign.NTSB LAX94LA270Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · San Carlos, CAthe student pilot's attempt to exit the runway at an excessive taxi speed which resulted in his loss of control.NTSB CHI94LA214Accident · Minor injuriesLimited investigationFinal reportLake LA-250 · Jefferson City, MOthe pilot allowing the airplane to get into an uncontrolled porpoising situation. A factor related to the accident was the choppy water.NTSB FTW94LA213Accident · Serious injuriesLimited investigationFinal reportDerr TRI-Q-100 · Albuquerque, NMThe pilot's improper recovery from a bounced landing and his inability to maintain directional control. A factor was the high density altitude.