NTSB investigations, NE
161 cases where NTSB found Aircraft.
Cases per year
| 2008 | 10 |
|---|---|
| 2009 | 9 |
| 2010 | 8 |
| 2011 | 6 |
| 2012 | 14 |
| 2013 | 5 |
| 2014 | 10 |
| 2015 | 7 |
| 2016 | 6 |
| 2017 | 9 |
| 2018 | 11 |
| 2019 | 9 |
| 2020 | 8 |
| 2021 | 6 |
| 2022 | 12 |
| 2023 | 6 |
| 2024 | 15 |
| 2025 | 8 |
| 2026 | 2 |
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\" = 'NE' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01'))
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" = 'NE' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01')) 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 CEN26LA286Accident · No injuriesClass 4 · LimitedFinal reportCessna T188C · Randolph, NEThe pilot’s failure to maintain clearance from a tree during a low-level aerial application flight.NTSB CEN26LA289Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 Raven 1 · Scribner, NEThe pilot's failure to maintain clearance from power lines while maneuvering at low-level altitude during an agricultural operation.NTSB CEN25LA376Accident · No injuriesClass 4 · LimitedFinal reportCessna 180H · Omaha, NEThe flight instructor’s failure to maintain directional control during landing in the tailwheel equipped airplane.NTSB CEN25LA292Accident · No injuriesClass 4 · LimitedFinal reportBell 206B · North Bend, NEThe pilot’s failure to maintain clearance from wires while maneuvering at a low altitude, and the ground crew failure to inform the pilot that the support truck had been moved.NTSB CEN25LA274Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT502 · Hastings, NEThe pilot’s failure to maintain clearance from powerlines while maneuvering at low altitude.NTSB CEN25LA191Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-401 · Hamlet, NEThe pilot's failure to maintain clearance from the power lines during low altitude maneuvering.NTSB CEN25LA179Accident · No injuriesClass 4 · LimitedFinal reportCessna 177RG · Wahoo, NEThe pilot’s failure to maintain clearance from an obstacle during taxi operations.NTSB CEN25LA150Accident · No injuriesClass 4 · LimitedFinal reportSilvaire 8F · Fairbury, NEThe pilot’s failure to maintain directional control while landing and the flight instructors delayed remedial action.NTSB CEN25LA120Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · Lincoln, NEA failure of the flight crew to ensure that the landing gear was properly extended before landing.NTSB CEN25LA080Accident · Serious injuriesClass 4 · LimitedFinal reportLuscombe 8 · Omaha, NEThe pilot’s inadequate preflight inspection, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN25LA029Accident · Minor injuriesClass 3 · LimitedFinal reportCub Crafters Carbon CUB · Ogallala, NEThe improper installation of the elevator control cable hardware, which resulted in the separation of the elevator control cable and a loss of pitch control in flight.NTSB CEN25FA006Accident · 1 fatalClass 3 · FieldFinal reportBeech C99 · Norfolk, NEThe pilot’s failure to maintain adequate airspeed following a partial loss of engine power during takeoff, which resulted in a loss of airplane control. Contributing to the accident was the fatigue failure of the compressor turbine fan disk blade.NTSB CEN24LA365Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Lincoln, NEThe student pilot’s failure to maintain directional control during landing.NTSB CEN24LA345Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Grand Island, NEThe pilot’s inadequate preflight planning/preparation that resulted in fuel exhaustion during cruise flight, a total loss of engine power, and an impact with terrain during a forced landing.NTSB CEN24LA332Accident · 1 fatalClass 3 · LimitedFinal reportApex CROSS-5X · Columbus, NEThe non-certificated pilot’s failure to maintain control of the aircraft after takeoff.NTSB CEN24FA327Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-140 · Wayne, NEThe non-instrument-rated pilot’s encounter with instrument meteorological conditions, which resulted in spatial disorientation and a loss of control.NTSB CEN24FA326Accident · 1 fatalClass 3 · FieldFinal reportRans S19 · Crofton, NEThe non-instrument-rated pilot's decision to continue visual flight into an area of low cloud cover and precipitation which resulted in an inadvertent encounter with instrument meteorological conditions and a loss of control due to spatial disorientation.NTSB CEN24LA293Accident · No injuriesClass 4 · LimitedFinal reportBeech F33A · Lincoln, NEThe pilot’s failure to maintain directional control during the landing roll with a crosswind.NTSB CEN24LA291Accident · No injuriesClass 3 · LimitedFinal reportAyres S2R-G6 · Antioch, NEA total loss of engine power due to fuel contamination from an undetermined source.NTSB CEN24LA285Accident · Serious injuriesClass 4 · LimitedFinal reportCessna A188B · Sumner, NEThe pilot’s failure to maintain clearance from a power line during the spray pass.NTSB CEN24LA272Accident · No injuriesClass 3 · LimitedFinal reportAir Tractor AT-602 · Oakland, NEThe pilot’s failure to maintain coordinated flight during aerial-application operations, which resulted in fuel migration between the interconnected wing fuel tanks, and his failure to adequately monitor fuel levels during the flight which resulted in a loss…NTSB CEN24LA269Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-36-375 · Avoca, NEA partial loss of engine power due to the loose left magneto which resulted in erratic engine timing.NTSB CEN24LA274Accident · No injuriesClass 4 · LimitedFinal reportCessna A188 · David City, NEThe pilot’s failure to maintain directional control during takeoff.NTSB CEN24LA349Accident · No injuriesClass 4 · LimitedFinal reportCessna 172R · Hooper, NEThe solo student pilot’s unstable approach to the runway, which resulted in a hard, bounced landingNTSB CEN24LA187Accident · Serious injuriesClass 4 · LimitedFinal reportAviat A1 · Poole, NEThe non-certificated pilot’s failure to configure the airplane for takeoff, which resulted in a runway excursion.NTSB CEN24FA028Accident · 1 fatalClass 3 · FieldFinal reportPiper PA46 · McCook, NEThe pilot exceeded the airplane’s critical angle of attack during the initial climb, resulting in an aerodynamic stall from which he could not recover. Contributing to the accident was the pilot’s decision to take off with the airplane well above its maximum…NTSB CEN23LA232Accident · No injuriesClass 3 · LimitedFinal reportGrumman Acft ENG Cor-Schweizer G-164B · Bloomfield, NEA partial loss of engine power during takeoff for reasons that could not be determined.NTSB CEN23FA220Accident · 1 fatalClass 3 · FieldFinal reportVans RV7 · Gibbon, NEThe pilot’s improper decision to fly the airplane into known adverse weather and icing conditions which resulted in a loss of control.NTSB CEN23LA171Accident · No injuriesClass 4 · LimitedFinal reportKitfox IV · Gretna, NEThe pilot’s failure to maintain clearance from terrain during a turn immediately after takeoff.NTSB CEN23LA090Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8KCAB · Hyannis, NEThe pilot’s failure to maintain clearance from a snowbank during landing, which resulted in a nose-over.NTSB CEN23FA077Accident · 2 fatalClass 3 · FieldFinal reportCessna 150H · Auburn, NEThe flight instructor’s failure to maintain control after a loss of engine power due to carburetor icing while maneuvering for forced landing in dark night visual meteorological conditions.NTSB CEN23FA031Accident · 2 fatalClass 3 · FieldFinal reportPiper PA46-500TP · Bignell, NEThe pilot’s flight into low instrument flight rules conditions and turbulence, which resulted in spatial disorientation, loss of control, and an impact with terrain. Contributing to the accident was the pilot’s lack of total instrument experience.NTSB CEN22LA408Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Murray, NEThe pilot’s failure to maintain airplane control during landing resulting in an impact with crop and a subsequent ground-loop. Contributing was the wet turf airstrip.NTSB CEN22LA345Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R44 II · Ithaca, NEThe pilot’s failure to maintain clearance from power lines during low level aerial application operations due to a distraction.NTSB WPR22FA266Accident · 2 fatalClass 3 · FieldFinal reportHolland Mike RV9A · Tryon, NEThe non-instrument-rated pilot’s decision to continue visual flight into instrument meteorological conditions, which resulted in spatial disorientation, a loss of control, exceedance of the airplane’s design limitations, and in-flight breakup of the airplane…NTSB CEN22LA327Accident · No injuriesClass 4 · LimitedFinal reportChampion 7KCAB · Gordon, NEThe pilot’s loss of control while landing a tailwheel-equipped airplane with a gusty crosswind.NTSB CEN22LA341Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 421B · Riverdale, NEA total loss of engine power as a result of fuel exhaustion.NTSB CEN22LA309Accident · No injuriesClass 3 · LimitedFinal reportCessna 172M · Friend, NEA loss of engine power due to a stuck valve.NTSB CEN22LA260Accident · Minor injuriesClass 3 · LimitedFinal reportSmith Miniplane DSA-1 · Union, NEThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ERA22FA233Accident · 1 fatalClass 3 · FieldFinal reportCessna 140 · Wayne, NEThe pilot’s exceedance of the airplane’s critical angle of attack on final approach while conducting traditional short takeoff and landing operations in gusting wind conditions, which resulted in an aerodynamic stall and spin from which the pilot could not…NTSB CEN22LA132Accident · No injuriesClass 3 · LimitedFinal reportMooney M20C · Crete, NEThe pilot’s failure to maintain control of the airplane during takeoff.NTSB CEN22LA117Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR22T · Lincoln, NEThe pilot’s decision to continue the flight with abnormal engine indications and the subsequent failure of the No. 5 cylinder connecting rod for unknown reasons.NTSB CEN22LA099Accident · No injuriesClass 4 · LimitedFinal reportCessna 177B · Wahoo, NEThe pilot’s failure to maintain directional control during the landing.NTSB CEN21LA351Accident · Serious injuriesClass 3 · LimitedFinal reportCozy Mark IV · Rushville, NEA total loss of engine power due to an obstruction of airflow to the engine as a result of the landing brake being deployed in flight.NTSB CEN21LA348Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Merry, NEThe pilot’s failure to maintain clearance from a wire during a low-level aerial application flight.NTSB CEN21LA264Accident · No injuriesClass 3 · LimitedFinal reportBoeing B75N1 · Elwood, NEThe failure of the engine master rod, resulting in a total loss of engine power and a forced landing.NTSB CEN21LA242Accident · Minor injuriesClass 3 · LimitedFinal reportPiper J4A · Omaha, NEA total loss of engine power due to a blocked fuel tank cap vent hole, which resulted in fuel starvation. Contributing to the accident was the mechanic’s and the pilot’s inadequate inspections of the fuel tank cap.NTSB CEN21LA206Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Curtis, NEWater contamination of the airplane’s fuel supply which resulted in a total loss of engine power.NTSB CEN21LA179Accident · Serious injuriesClass 4 · LimitedFinal reportDestiny Powered Parachutes 2000 · Saint Paul, NEThe uncertificated pilot’s failure to maintain control of the powered parachute during low altitude flight in gusting wind conditions.NTSB CEN21LA097Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Albion, NEThe pilot’s failure to maintain directional control during the landing with a tailwind.