Major NTSB investigations
9 cases where the first occurrence was “Loss of control - on ground/water”.
Cases per year
| 1984 | 1 |
|---|---|
| 1989 | 1 |
| 1993 | 2 |
| 1995 | 2 |
| 1996 | 1 |
| 1997 | 1 |
| 1999 | 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.board_report_url IS NOT NULL OR c.\"investigationClass\" = 'Class 1' OR c.\"caseType\" = 'Major - Launch')
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\" = 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.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch') 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" = 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 DCA99MA060Accident · 11 fatalClass 1 · MajorFinal reportMcDonnell Douglas MD-82 · Little Rock, ARThe flight crew's failure to discontinue the approach when severe thunderstorms and their associated hazards to flight operations had moved into the airport area and the crew's failure to ensure that the spoilers had extended after touchdown. Contributing to…NTSB DCA97MA053Accident · No injuriesMajor investigationFinal reportMcDonnell Douglas MD-11 · Honolulu, HIThe pilot's failure to apply adequate manual control inputs following his decision to disconnect the autopilot during the autoland operation, resulting in a subsequent loss of directional control. Also causal and contributing to the tail strike was the…NTSB CHI97MA017Accident · 4 fatalMajor investigationFinal reportGulfstream G-IV · Wheeling, ILfailure of the pilot-in-command (PIC) to maintain directional control of the airplane during the takeoff roll in a gusty crosswind, his failure to abort the takeoff, and failure of the copilot to adequately monitor and/or take sufficient remedial action to…NTSB DCA96MA029Accident · Serious injuriesClass 1 · MajorFinal reportBoeing 747-136 · Jamaica, NYthe captain's failure to reject the takeoff in a timely manner when excessive nosewheel steering tiller inputs resulted in a loss of directional control on a slippery runway. Inadequate Boeing 747 slippery runway operating procedures developed by Tower Air,…NTSB DCA95MA020Accident · 3 fatalClass 1 · MajorFinal reportDouglas DC-8-63 · Kansas City, MO(1) The loss of directional control by the pilot in command during the takeoff roll, and his decision to continue the takeoff and initiate a rotation below the computed rotation airspeed, resulting in a premature liftoff, further loss of control and collision…NTSB DCA93MA040Accident · Serious injuriesClass 1 · MajorFinal reportDouglas DC-10-30 · Dallas/Ft Worth, TXThe national transportation safety board determines that the probable cause of the accident was the failure of the captain to use proper directional control techniques to maintain the airplane on the runway.NTSB ATL93MA055Accident · 7 fatalMajor investigationFinal reportLockheed L382E-44K-20 · Marietta, GADisengagement of the rudder fly-by-wire flight control system resulting in a total loss of rudder control capability while conducting ground minimum control speed tests. The disengagement was a result of the inadequate design of the rudder's integrated…NTSB DCA89MA074Accident · 2 fatalClass 1 · MajorFinal reportBoeing 737-400 · Flushing, NYThe captain's failure to exercise his command authority in a timely manner to reject the takeoff or take sufficient control to continue the takeoff, which was initiated with a mistrimmed rudder. Also causal was the captain's failure to detect the mistrimmed…NTSB ANC84MA037Accident · No injuriesMajor investigationFinal reportEmbraer EM-110P1 · Cordova, AKDuring a landing at night, the acft touched down slightly left of the rwy centerline, which was not visible, & began veering to the left. The plt reported that the acft did not respond to rudder inputs, rudder tiller inputs or differential reverse thrust. It…