NTSB investigations
1,681 cases where the first occurrence was “Overrun”.
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\" = 340) 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" = 340) 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 FTW95LA233Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Collegeport, TXThe pilot's improper planning/decision by attempting to takeoff in an overweight condition from an 1,800 foot runway. Factors were the wet and soft condition of the runway.NTSB CHI95LA162Accident · No injuriesLimited investigationFinal reportBeech C23 · Lake Ann, MIthe pilot's inadequate preflight planning/preparation and improper short field landing procedures. Factors associated with the accident were the wet terrain, a tailwind, and the pilots lack of recent experience.NTSB BFO95LA054Accident · No injuriesLimited investigationFinal reportCessna 172N · Head Waters, VAthe pilot's poor planning/decision making in the attempted departure. Contributing factors are the wet, recently mowed grass airstrip, and the embankment/downhill grade encountered during the aborted takeoff.NTSB FTW95LA220Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Stephenville, TXThe pilot's failure to execute a go-around. Factors were the excessive airspeed and high glidepath during the approach.NTSB SEA95LA107Accident · No injuriesLimited investigationFinal reportCessna 172B · Sinclair Island, WAThe pilot's failure to attain the proper touchdown point. Contributing to the accident were a tailwind, wet grass, and the pilot's inadequate remedial action.NTSB NYC95LA121Accident · No injuriesLimited investigationFinal reportCessna 182E · Frederick, PAThe pilot's inadequate inflight planning by failing to verify the wind direction for landing. Also causal is the pilot's failure to obtain the proper touch down point and to do a go-around.NTSB LAX95LA197Accident · No injuriesLimited investigationFinal reportBölkow Phoebus C · Helendale, CAthe pilot's selection of a downwind landing and his failure to attain the proper touchdown point. Factors in the accident were the inaccurate wind information provided by his ground crew which led the pilot to select the improper landing direction, and, the…NTSB FTW95TA218Accident · No injuriesFinal reportCessna R172K · Albuquerque, NMThe pilot's improper compensation for crosswind conditions. Factors were the crosswind, the proper touchdown point not attained, and the pilot not aborting the landing.NTSB NYC95LA117Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Louisville, KYThe pilot's inadequate planning which resulted in his failure to attain adequate airspeed for takeoff.NTSB NYC95LA113Accident · 1 fatalLimited investigationFinal reportBeech A23-24 · Atlantic City, NJThe pilot's delayed decision to abort the landing. Factors in the accident were: the downwind landing and the pilot's misjudgment of distance and speed.NTSB LAX95LA187Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Oakland, CAThe pilot's poor preflight planning/preparation by exceeding the airplane certificated maximum allowable takeoff gross weight and failure to abort the takeoff in a timely manner. The ditch was a factor in this accident.NTSB FTW95LA195Accident · Minor injuriesLimited investigationFinal reportMooney M20F · Frederick, COThe pilot's use of unsuitable terrain for takeoff and his delay in initiating an abort. Factors were a soft and wet air strip.NTSB CHI95LA129Accident · No injuriesLimited investigationFinal reportBeech B19 · Omaha, NEThe pilot misjudged distance and speed. A factor was turbulence.NTSB ATL95LA086Accident · No injuriesLimited investigationFinal reportCessna 182R · Conyers, GAThe pilot's failure to maintain a proper touchdown point during the landing, and his failure to perform a go around when a long landing was imminent. Factors were the sudden windshift resulting in a tailwind condition, and the downhill landing conditions.NTSB ATL95LA075Accident · No injuriesLimited investigationFinal reportCessna 182J · Calera, ALThe pilots improper decision to land downwind on the short runway.NTSB BFO95LA040Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Lakewood, NJThe pilot's inadequate compensation for wind conditions and his inadequate evaluation of the weather conditions which resulted in an overrun. A factor is the sudden windshift.NTSB ATL95LA068Accident · Minor injuriesLimited investigationFinal reportPiper PA-60 · Linden, TNThe pilot's failure to attain a proper touchdown point resulting in the aircraft overrunning the runway. Gusty weather conditions and the wet runway were also contributing factors.NTSB ATL95LA060Accident · No injuriesLimited investigationFinal reportCessna 182P · Alabaster, ALThe pilot's failure to perform an adequate preflight inspection of the aircraft, which resulted in a takeoff with the control wheel lock installed.NTSB MIA95LA074Accident · No injuriesLimited investigationFinal reportCessna 525 · Wauchula, FLImproper in-flight planning and decision by the pilot-in-command resulting in excessive airspeed on approach. A contributing factor was the improper decision of the pilot-in-command not to execute a go-around while adequate runway remained.NTSB FTW95LA110Accident · No injuriesLimited investigationFinal reportCessna 172M · Boulder, COThe pilot's premature rotation.NTSB CHI95LA083Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Lafayette, INthe pilot's failure to perform a go-around. The gusty crosswind was a factor in the accident.NTSB ATL95LA047Accident · 2 fatalLimited investigationFinal reportBrandt Rutan Longeze · Marietta, GAThe pilot's delayed abort of the ground run which resulted in a runway overrun and collision with the ravine.NTSB FTW95LA104Accident · Serious injuriesLimited investigationFinal reportCessna 172H · Mountain View, ARThe pilot's selection of a downwind runway for takeoff, his failure to use all available runway, and delay in aborting the takeoff. A factor was the tailwind.NTSB CHI95LA072Accident · No injuriesLimited investigationFinal reportStuart/Wagner Mountain Eagle · Halliday, NDThe pilot's premature lift-off and delayed aborted takeoff.NTSB CHI95LA070Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Cottage Grove, WIThe pilot's selection of unsuitable terrain/runway for landing. Factors related to the accident were: the unfavorable wind, icy runway condition, and snowbank at the end of the runway.NTSB ATL95IA043Incident · No injuriesIncident investigationFinal reportBoeing 737-247 · Atlanta, GAThe inadequate inspection of the aircraft by other maintenance personnel, in that they did not properly diagnose discrepancies in the antiskid braking system.NTSB NYC95LA048Accident · No injuriesLimited investigationFinal reportAero Commander 560F · Canfield, OHThe pilot's decision to abort the takeoff on a snow and ice covered runway, and once made, the pilot's decision to lower the flaps.NTSB NYC95LA044Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Gr. Barrington, MAThe pilot landed with excessive airspeed which resulted in a long landing, runway overrun, and collision with trees.NTSB ATL95LA028Accident · Minor injuriesLimited investigationFinal reportCessna 402B · Hickory, NCThe pilot's failure to attain a proper touchdown point during the transition to landing, which resulted in a long landing and overrun. Factors were the low ceilings and fog which prevailed at the time of the accident.NTSB MIA95LA036Accident · Serious injuriesLimited investigationFinal reportColvin Kitfox II · Fort Pierce, FLThe failure of the pilot to abort the takeoff when he encountered water on the grass runway.NTSB FTW95LA062Accident · No injuriesLimited investigationFinal reportCessna 172B · Seguin, TXThe pilot's failure to attain proper touchdown point.NTSB NYC95LA032Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Freeport, PAThe pilot's attempted takeoff in an overweight airplane, his failure to follow approved short field takeoff procedures, not attaining a positive rate of climb, and attempting an operation beyond his experience level.NTSB SEA95LA014Accident · No injuriesLimited investigationFinal reportCessna 205A · Lowell, IDThe pilot in command's long and fast landing. A factor was the wet runway surface condition.NTSB NYC95LA018Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-300 · Pillow, PAThe pilot did not attain the proper touchdown point on a grass runway covered with frost, which resulted in inadequate braking, and runway overrun.NTSB CHI95LA020Accident · No injuriesLimited investigationFinal reportCessna 182P · Bremen, INthe pilot's failure to perform a go-around prior to touchdown. Factors to the accident were the tailwind, excessive airspeed, the rough terrain and the powerlines.NTSB ATL95FA005Accident · 2 fatalField investigationFinal reportGulfstream American AA-5A · Lexington, NCThe pilot's operation of the aircraft with a known deficiency (foreign material or particle in the pitot tube), which led to a false airspeed indication and premature lift-off of the aircraft during takeoff, and the pilot's improper remedial action that…NTSB LAX95LA009Accident · No injuriesLimited investigationFinal reportCessna 177RG · Laytonville, CAwere the pilot's failure to maintain the proper airspeed and attain the proper touchdown point.NTSB FTW94LA320Accident · No injuriesLimited investigationFinal reportPiper PA-39 · Andrews, TXThe pilot's failure to initiate a go-around after encountering a tailwind. A factor was the tailwind.NTSB LAX94LA384Accident · No injuriesLimited investigationFinal reportCessna 152 · Petaluma, CAthe failure of the pilot to initiate a go-around after failing to obtain the proper airspeed and rate of descent during the approach.NTSB NYC94LA181Accident · No injuriesLimited investigationFinal reportCessna 172P · Sterling, MAThe pilot misjudged landing distance, which resulted in an overrun of the runway. A factor is the pilot's failure to do a go-around.NTSB NYC94LA175Accident · No injuriesLimited investigationFinal reportCessna T210R · Tunkhannock, PAUse of improper procedures during a short field landing which resulted in an overrun and noseover.NTSB CHI94LA318Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · West Branch, MIthe pilot's improper preflight planning in estimating the takeoff distance. The tall, wet grass on the runway was a factor.NTSB CHI94LA326Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Brookfield, WIthe commercial pilot's poor planning/decision making. A related factor is the wet, grass runway selected for landing.NTSB SEA94LA230Accident · No injuriesLimited investigationFinal reportCessna 182B · Lummi Island, WAInadequate compensation for wind conditions. A factor to the accident was: tailwind.NTSB NYC94LA164Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Block Island, RIThe pilot maintaining excessive airspeed during the landing, resulting in a touchdown on the runway with insufficient distance to stop, and a subsequent intentional ground loop and collision with the terrain. Also causal was the pilot's failure to abort the…NTSB CHI94LA305Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Jackson, MNthe pilot's selection of unsuitable terrain for takeoff and his delay in aborting the takeoff. Factors in the accident were the soft terrain and the ditch.NTSB LAX94LA338Accident · No injuriesLimited investigationFinal reportBeech A36 · So. Lake Tahoe, CAthe pilot's delayed decision to abort the takeoff when the performance deficiency first became apparent.NTSB BFO94LA142Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Leesburg, OHThe pilot misjudged his altitude and airspeed during landing resulting in an overrun and collision with a fence. A related factor was the wet runway.NTSB LAX94LA329Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Oakdale, CA1) The flight instructor's failure to attain a proper touchdown point on the runway, 2) his failure to initiate a timely go around, and 3) his inadequate supervision of the flight.NTSB SEA94LA216Accident · No injuriesLimited investigationFinal reportCessna 170B · Redmond, ORProper touchdown point was not attained. A factor to the accident was inadequate remedial action.