Skip to content

NTSB investigations

6,629 cases where the first occurrence was “Loss of control - on ground/water”.

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" = 260) 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\" = 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 ANC96LA104Accident · No injuriesLimited investigationFinal reportCessna 170B · Tyonek, AKThe pilot's failure to maintain directional control during the landing roll.Jul 18, 1996 · N2813C · Substantial damage NTSB NYC96LA151Accident · No injuriesLimited investigationFinal reportAmerican Champion 7EC · Rochester, NHthe pilot's inadequate compensation for winds and his failure to maintain directional control, which resulted in a ground loop and dragging of the wing on the runway.Jul 17, 1996 · N8910R · Substantial damage NTSB IAD96LA114Accident · No injuriesLimited investigationFinal reportCessna 152 · Blue Ash, OHfailure of the pilot to maintain directional control of the airplane, while rolling to takeoff from a touch-and-go landing.Jul 14, 1996 · N6468Q · Substantial damage NTSB CHI96LA243Accident · No injuriesLimited investigationFinal reportBeech C-45H · Marshall, MIfailure of the pilot to maintain directional control during the takeoff roll, which resulted in an inadvertent ground swerve. The crosswind (quartering headwind) was a related factor.Jul 14, 1996 · N9772Z · Substantial damage NTSB SEA96LA158Accident · No injuriesLimited investigationFinal reportCessna 170B · Arlington, WAthe pilot's failure to maintain directional control during landing, which resulted in an inadvertent ground swerve. The crosswind and wet runway were related factors.Jul 13, 1996 · N170EC · Substantial damage NTSB NYC96LA149Accident · No injuriesLimited investigationFinal reportCessna 172P · Fairfield, NJthe pilot's improper aborted takeoff by extending full flaps which resulted in a porpoise. Subsequently, the airplane veered off the runway and the nose gear collapsed.Jul 13, 1996 · N98730 · Substantial damage NTSB LAX96LA271Accident · No injuriesLimited investigationFinal reportCessna 180 · Thermal, CAThe pilot's inadequate compensation for the existing wind conditions.Jul 13, 1996 · N4740B · Substantial damage NTSB ANC96LA126Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Kotzebue, AKThe pilot's failure to maintain directional control while landing.Jul 13, 1996 · N2561N · Substantial damage NTSB SEA96LA156Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Arock, ORfailure of the pilot to maintain directional control of the aircraft during the landing, which resulted in an inadvertent ground loop. The tailwind was a related factor.Jul 12, 1996 · N8692K · Substantial damage NTSB SEA96LA153Accident · No injuriesLimited investigationFinal reportCessna 170B · Lewistown, MTthe pilot's inadequate compensation for the changing wind conditions, and his failure to maintain directional control, which resulted in an inadvertent ground swerve. The sudden windshift was a related factor.Jul 12, 1996 · N3156A · Substantial damage NTSB IAD96LA112Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Salisbury, MDthe student pilot's failure to maintain directional control during the takeoff roll.Jul 11, 1996 · N91493 · Substantial damage NTSB SEA96LA151Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Stanley, IDthe pilot's inadequate compensation for the wind conditions, and his failure to maintain directional control of the airplane, which resulted in an inadvertent ground swerve. The crosswind was a related factor.Jul 10, 1996 · N5352P · Substantial damage NTSB LAX96LA269Accident · No injuriesLimited investigationFinal reportBowles/Irwin Questair Venture · Groveland, CAthe pilot's failure to maintain directional control while landing in a crosswind. A contributing factor was related to the airplane's steering/handling characteristics.Jul 9, 1996 · N65V · Substantial damage NTSB FTW96LA296Accident · No injuriesLimited investigationFinal reportCessna 180J · Mountain Home, ARThe pilot's failure to maintain directional control during landing. A factor was the cross wind.Jul 8, 1996 · N46524 · Substantial damage NTSB IAD96LA108Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Cambridge, MDthe pilot's failure to maintain control of the airplane during landing. The crosswind was a factor.Jul 7, 1996 · N87910 · Substantial damage NTSB CHI96LA230Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Valparaiso, INthe pilot's failure to maintain directional control of the airplane during the landing roll.Jul 5, 1996 · N8352H · Substantial damage NTSB IAD96LA104Accident · No injuriesLimited investigationFinal reportTaylorcraft F-19 · Mitchellville, MDthe pilot's failure to maintain directional control of the aircraft during the landing roll. Related factors were the gusty crosswind conditions.Jul 4, 1996 · N2004A · Substantial damage NTSB ANC96LA094Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Cantwell, AKThe pilot's inadequate compensation for the crosswind conditions. A factor in the accident was the crosswind.Jul 3, 1996 · N57617 · Substantial damage NTSB LAX96LA259Accident · Minor injuriesLimited investigationFinal reportBeech 95-B55 · Ramona, CAThe pilot's failure to maintain directional control of the aircraft.Jul 2, 1996 · N386T · Substantial damage NTSB LAX96LA257Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Redlands, CAthe CFI's delayed remedial action by not preventing the airplane's departure from the runway, and his failure to maintain airspeed sufficient to avoid stalling during an attempted low altitude climbing turn.Jul 2, 1996 · N2931V · Destroyed NTSB ATL96LA099Accident · No injuriesLimited investigationFinal reportCessna 188 · Pelham, GAfailure of the pilot to maintain directional control on the takeoff roll, which resulted in the airplane veering off the runway and colliding with a cotton picker (vehicle).Jul 1, 1996 · N9088R · Substantial damage NTSB ATL96LA098Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Calhoun, GAthe pilot's failure to maintain directional control during landing.Jun 30, 1996 · N7685K · Substantial damage NTSB LAX96LA253Accident · Minor injuriesLimited investigationFinal reportCessna P210 · Grand Canyon, AZfailure of the pilot to use his brakes to maintain directional control.Jun 29, 1996 · N4766K · Destroyed NTSB LAX96LA251Accident · No injuriesLimited investigationFinal reportCessna 152 · Santa Rosa, CAthe solo student pilot misjudged the landing flare resulting in a hard landing. A factor in the accident was low airspeed.Jun 29, 1996 · N68459 · Substantial damage NTSB CHI96LA227Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Cottage Grove, WIthe pilot's failure to maintain directional control of the airplane during landing. A factor was the delayed go-around.Jun 27, 1996 · N1674E · Substantial damage NTSB SEA96LA135Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Vancouver, WAfailure of the pilot to maintain directional control of the airplane during take-off, which resulted in an inadvertent ground swerve and subsequent dragging of the right wing. The pilot's lack of experience in the make/model of aircraft was a related factor.Jun 23, 1996 · N81966 · Substantial damage NTSB LAX96LA242Accident · No injuriesLimited investigationFinal reportPiper PA-34-200 · Avalon, CAThe failure of the left brake for undetermined reasons.Jun 23, 1996 · N507TH · Substantial damage NTSB MIA96LA160Accident · No injuriesLimited investigationFinal reportCessna 150L · Sanford, FLfailure of the pilot to maintain directional control of the airplane during the landing, which resulted in a ground swerve and subsequent nose over.Jun 19, 1996 · N11532 · Substantial damage NTSB ANC96LA090Accident · No injuriesLimited investigationFinal reportCessna 170B · Fairbanks, AKThe pilot's selection of unsuitable terrain for landing and the failure to maintain directional control of the airplane. A factor in the accident was an airstrip that was rough and uneven.Jun 17, 1996 · N2848C · Substantial damage NTSB NYC96LA128Accident · No injuriesLimited investigationFinal reportCessna 180 · Fulton, NYThe pilot's inadequate compensation for wind conditions.Jun 15, 1996 · N7783A · Substantial damage NTSB FTW96LA246Accident · No injuriesLimited investigationFinal reportCessna 172N · Farmington, NMfailure of the pilot to maintain directional control during a touch-and-go landing, which resulted in a ground swerve and subsequent collision with a parked airplane.Jun 12, 1996 · N3535E · Substantial damage NTSB ANC96TA087Accident · No injuriesFinal reportCessna 185F · Gustavus, AKThe pilot's inadequate compensation for the wind conditions. A factor associated with the accident was a crosswind.Jun 11, 1996 · N56581 · Substantial damage NTSB SEA96LA118Accident · No injuriesLimited investigationFinal reportCessna 180 · Kalispell, MTfailure of the pilot to maintain directional control, due to inadequate compensation for wind conditions. Factors relating to the accident were: the crosswind and soft/wet terrain near the edge of the runway.Jun 9, 1996 · N2411C · Substantial damage NTSB LAX96LA227Accident · No injuriesLimited investigationFinal reportCessna 172N · Prescott, AZThe failure of the pilot to adequately compensate for gusty crosswind conditions, which resulted in loss of aircraft control.Jun 9, 1996 · N737WR · Substantial damage NTSB ANC96LA086Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Fairbanks, AKThe obstruction of the left rudder pedal and brake by the battery cable.Jun 9, 1996 · N8560C · Substantial damage NTSB NYC96LA121Accident · No injuriesLimited investigationFinal reportPiper J-3 · Chester, CTthe pilot's improper use of rudder control to maintain directional control during landing.Jun 6, 1996 · N68952 · Substantial damage NTSB LAX96FA228Accident · No injuriesField investigationFinal reportBritish Aerospace BA-3100/3201 · San Luis Obispo, CAThe flight crew's loss of directional control resulting from an attempted takeoff with the left propeller on the start lock. Factors in the accident were: the lack of cockpit caution/warning system/lights available to verify that the propellers are out of the…Jun 6, 1996 · N926AE · Substantial damage NTSB ANC96LA084Accident · No injuriesLimited investigationFinal reportSwearingen SA-26 · Galena, AKthe pilot's selection of an unsuitable landing site. Factors associated with the accident were the soft and uneven airstrip conditions.Jun 5, 1996 · N501FS · Substantial damage NTSB SEA96LA107Accident · No injuriesLimited investigationFinal reportPiper PA-20 · Pasco, WAthe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent ground swerve and collapse of the left main gear.Jun 1, 1996 · N1645A · Substantial damage NTSB NYC96LA119Accident · No injuriesLimited investigationFinal reportCessna 172F · Blairstown, NJthe pilot's failure to maintain directional control due to improper compensation for wind conditions.Jun 1, 1996 · N8869U · Substantial damage NTSB CHI96LA182Accident · No injuriesLimited investigationFinal reportMooney M20F · Festus, MOthe pilot's not maintaining proper alignment with the runway and his inadequate compensation for wind conditions. A factor was the crosswind condition.May 31, 1996 · N9532M · Substantial damage NTSB CHI96LA181Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Des Moines, IAthe pilot's inadvertent use of the brakes which resulted in a loss of directional control. A factor associated with the accident was the ravine which the airplane traveled down.May 29, 1996 · N396BG · Substantial damage NTSB LAX96LA212Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW-20 · Sparks, NVthe pilot's inadequate compensation for wind conditions during the takeoff roll, and his failure to maintain control of the glider. The gusty wind condition was a related factor.May 28, 1996 · N204Q · Substantial damage NTSB CHI96LA177Accident · No injuriesLimited investigationFinal reportCessna U206 · Inver Grove, MNthe pilot's improper recovery from the bounced landing. The gusty wind condition was a factor.May 28, 1996 · N5192U · Destroyed NTSB CHI96LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28-201T · Wichita, KSthe pilot's failure to maintain directional control of the airplane during landing. A factor associated with the accident was the gusty crosswind condition.May 28, 1996 · N77782 · Substantial damage NTSB NYC96LA114Accident · Minor injuriesLimited investigationFinal reportWaco UPF-7 · East Canton, PAthe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control, which resulted in a loss of control and subsequent collision with obstacles. The gusty crosswind condition was a related factor.May 25, 1996 · N32091 · Substantial damage NTSB LAX96LA211Accident · No injuriesLimited investigationFinal reportBellanca 17-30A · Fallbrook, CAfailure of the pilot to attain the proper touchdown point on the runway, and his failure to maintain directional control of the airplane. Factors relating to the accident were: the excessive airspeed on final approach, and the short and wet condition of the…May 24, 1996 · N23MB · Substantial damage NTSB NYC96LA112Accident · No injuriesLimited investigationFinal reportAeronca 7EC · New Castle, PAthe pilot's failure to maintain directional control during the landing roll, which resulted in a ground swerve and an encounter with high grass and a ditch off the side of the runway.May 21, 1996 · N1536E · Substantial damage NTSB CHI96LA168Accident · No injuriesLimited investigationFinal reportCessna 188 · Roseau, MNthe pilot failed to maintain directional control during takeoff. The crosswind was a factor.May 21, 1996 · N2062J · Substantial damage NTSB SEA96LA096Accident · No injuriesLimited investigationFinal reportTilbert Baby Great Lakes · Stevensville, MTthe pilot's inadequate compensation for the wind conditions during the landing roll, which resulted in loss of directional control and an inadvertent ground swerve. Factors relating to the accident were: the adverse wind conditions (crosswind and gusts),…May 20, 1996 · N94AT · Substantial damage