NTSB investigations, NC
85 cases where NTSB found Aircraft systems.
Cases per year
| 2008 | 2 |
|---|---|
| 2009 | 5 |
| 2010 | 5 |
| 2011 | 2 |
| 2012 | 5 |
| 2013 | 9 |
| 2014 | 5 |
| 2015 | 6 |
| 2016 | 4 |
| 2017 | 7 |
| 2018 | 4 |
| 2019 | 4 |
| 2020 | 5 |
| 2021 | 3 |
| 2022 | 5 |
| 2023 | 6 |
| 2024 | 4 |
| 2025 | 2 |
| 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\" = 'NC' 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\", '0102'))
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" = 'NC' 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", '0102')) 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 ERA26LA213Accident · No injuriesClass 4 · LimitedFinal reportCessna 177RG · Statesville, NCThe pilot’s failure to extend the landing gear prior to landing.NTSB ERA26LA191Accident · No injuriesClass 4 · LimitedFinal reportBeech F33A · Sanford, NCA loss of electrical power as a result of broken stator leads within the alternator, which resulted in the pilot’s inability to extend the airplane’s landing gear.NTSB ERA25LA196Accident · Serious injuriesClass 4 · LimitedFinal reportChris Wallen/Michael Pliske Just Acft Highlander · Brasstown, NCThe pilot’s inadvertent application of brake pressure during landing, which resulted in a nose over.NTSB ERA25LA188Accident · No injuriesClass 3 · LimitedFinal reportCessna 172RG · Louisburg, NCMaintenance personnel’s failure to identify and remediate water contamination of the airplane’s fuel system, which resulted in a partial loss of engine power during initial climb.NTSB ERA24LA376Accident · No injuriesClass 4 · LimitedFinal reportBeech 58 · Raleigh, NCDamage to the landing gear selector switch wire bundle which resulted in an inadvertent retraction of the landing gear during the takeoff roll.NTSB ERA24LA354Accident · No injuriesClass 4 · LimitedFinal reportBeech 300 · Asheboro, NCThe pilot’s failure to extend the landing gear before landing.NTSB ERA24LA307Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-B55 · Greenville, NCA landing with the nose gear retracted as a result of an intermittent landing gear relay.NTSB ERA24LA186Accident · No injuriesClass 4 · LimitedFinal reportCessna 210 · Concord, NCFailure of a landing gear extension system hydraulic hose, which resulted in a landing with the landing gear retracted.NTSB ERA23LA298Accident · Serious injuriesClass 3 · LimitedFinal reportDouglas A-4K · MCAS Cherry Point, NCThe pilot’s failure to identify and appropriately respond to an anomalous nose-down trim condition during the takeoff roll, which resulted in his decision to eject and the airplane’s subsequent runway excursion.NTSB DCA23FA339Accident · No injuriesClass 3 · FieldFinal reportBoeing 717-200 · Charlotte, NCA fatigue fracture of the upper lock link that initiated along scratch features on the lower surface at the parting line of the forged aluminum component. Contributing to the accident was the overhaul facilities noncompliance with Service Bulletin 717-32-002.NTSB ERA23LA281Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-22-150 · Indian Trail, NCA loss of control during the landing roll due to a brake failure for reasons that could not be determined based on available evidence.NTSB CEN23LA230Accident · No injuriesClass 4 · LimitedFinal reportChampion 7KCAB · Rutherfordton, NCThe disengagement of the tailwheel locking mechanism during the landing roll which resulted in a loss of directional control during landing with a crosswind.NTSB ERA23LA262Accident · No injuriesClass 3 · LimitedFinal reportBurton Searey · Sherrills Ford, NCThe pilot’s failure to configure the amphibious airplane’s landing gear before conducting a forced landing to a lake after a loss of engine power. Also causal was the occluded gascolator and the pilot’s lack of knowledge about the airplane’s fuel system,…NTSB ERA23LA240Accident · 1 fatalClass 3 · LimitedFinal reportCessna R182 · Macon, NCThe pilot’s failure to properly set the elevator trim before takeoff, which resulted in a loss of control during takeoff.NTSB ERA23LA009Accident · Minor injuriesClass 3 · LimitedFinal reportSwensen Fisher Celebrity · Greensboro, NCThe pilot/mechanic’s failure to remove excess sealant from the header fuel tank after recent maintenance, which resulted in fuel starvation to the engine and a loss of engine power. Contributing to the accident was the pilot’s inflight decision making…NTSB ERA22LA277Accident · Serious injuriesClass 3 · LimitedFinal reportHawker Hunter · Wilmington, NCA bearing failure in the high-pressure fuel pump, which resulted in a partial loss of engine power.NTSB ERA22LA313Accident · Minor injuriesClass 3 · LimitedFinal reportWhittridge Twinstarr · Indian Trail, NCA blockage of the fuel filter inlet by a piece of debris, which resulted in fuel starvation and a total loss of engine power.NTSB ERA22LA177Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 170 · Stoney Point, NCThe pilot’s failure to retract the flaps during a go-around from a bounced landing, which resulted in a collision with trees then terrain.NTSB ERA22LA132Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · New Bern, NCThe loss of brake pressure on the left brake due to a failed O-ring seal.NTSB ERA21LA367Accident · Minor injuriesClass 4 · LimitedFinal reportCollins Robert S Just Acft Highlander · Brasstown, NCFailure of the left main landing gear wheel lock nuts, which resulted in a wheel separation and nose over during landing.NTSB ERA21LA298Accident · No injuriesClass 3 · LimitedFinal reportCarpenter Stol CH750 · Rockwell, NCThe total loss of engine power due to carburetor ice. Also causal was the pilot’s failure to apply carburetor heat at any time during the flight.NTSB ERA21LA114Accident · Minor injuriesClass 4 · LimitedFinal reportAviat A1 · Terrell, NCThe pilot’s failure to retract the landing gear on the amphibious airplane prior to a water landing, resulting in a nose over and structural damage to the airframe. The mechanic’s failure to remove electrical tape from the pitot tube, the pilot’s inadequate…NTSB ERA21LA075Accident · No injuriesClass 3 · LimitedFinal reportKolb Firestar · Durham, NCA total loss of engine power due to fuel starvation as the result of a degraded fuel primer check valve.NTSB ERA20LA295Accident · No injuriesClass 3 · LimitedFinal reportAeronca 11AC · Nebo, NCA leak in the main fuel tank that resulted in a total loss of engine power due to fuel starvation.NTSB ENG20LA043Incident · No injuriesClass 3 · LimitedFinal reportBombardier CL-600-2D24 · Charlotte, NCThe windshield failed due to arcing from an inadequate solder connection at the anti-ice power terminal block.NTSB ERA20CA152Accident · No injuriesData collectionFinal reportHolmgren Bearhawk · Ahoskie, NCThe collapse of the right main landing gear during a bounced, crosswind landing.NTSB ERA20LA127Accident · No injuriesClass 3 · LimitedFinal reportPiper PA23 · Albemarle, NCThe pilots' failure to ensure that the electric fuel pumps were on before takeoff, which resulted in a partial loss of power on both engines during initial climb.NTSB ERA20LA070Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 210 · Concord, NCA malfunction of the left main landing gear brake during landing for undetermined reasons. Contributing was the pilot’s failure to attain a proper touchdown point and maintain an appropriate approach speed while landing on the wet turf runway.NTSB ERA19FA201Accident · 2 fatalClass 2 · FieldFinal reportBeech E55 · Hope Mills, NCThe pilot's failure to disengage an uncommanded nose-down pitch input. Contributing to the accident was improper maintenance of the pitch trim servo, which would have precluded a physical override of the pitch servo.NTSB ERA19LA159Accident · Minor injuriesClass 3 · LimitedFinal reportZenair Zodiac CH601 · Angier, NCA partial loss of engine power due to partial interruption of the fuel supply for undetermined reasons.NTSB ERA19FA130Accident · 1 fatalClass 3 · FieldFinal reportMooney M20C · Cashiers, NCThe pilot's loss of airplane control due to spatial disorientation while flying in instrument meteorological conditions. Contributing to the accident was the failure of the vacuum pump and its associated instruments.NTSB GAA19CA017Accident · No injuriesData collectionFinal reportCessna 177RG · Albermarle, NCThe pilot's improper decision to attempt a gear-up glide to the runway and his subsequent failure to extend the landing gear before landing. Contributing to the accident was the pilot's failure to use a checklist before landing.NTSB ERA18TA179Accident · Minor injuriesFinal reportStearman B75 · Lexington, NCThe pilot’s overapplication of the wheel brakes during landing, which resulted in a nose-over.NTSB GAA18CA281Accident · No injuriesData collectionFinal reportPiper PA 32R · Cape Carteret, NCThe pilot’s steep approach, which resulted in a hard landing and the collapse of the landing gear during touchdown.NTSB ERA18LA087Accident · Minor injuriesClass 3 · LimitedFinal reportAero Commander Callair A 9 · Bunn, NCThe glider instructor's delayed remedial action when the glider became out of position during aerotow, which resulted in excessive side-loading of the release hook and a delay in the glider's release from tow, which resulted in the towplane’s descent and…NTSB ERA18TA059Accident · Minor injuriesFinal reportCessna 172 · Union Mills, NCThe pilot's failure to use carburetor heat in weather conditions conducive to serious carburetor icing, which resulted in a total loss of engine power and a subsequent forced landing.NTSB ERA18LA026Accident · No injuriesLimited investigationFinal reportPiper PA28 · Bladenboro, NCA loss of engine power due to carburetor icing and the presence of an insect nest in the carburetor heat control box that prevented the pilot’s application of carburetor heat from restoring engine power.NTSB ERA18FA012Accident · 1 fatalField investigationFinal reportBeech 35C33 · Whiteville, NCThe pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation, and his delayed reaction to the loss of engine power, which led to impact with trees as he was attempting to switch fuel tanks.…NTSB ERA18LA010Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A24 · Manteo, NCThe failure of maintenance personnel to properly secure wiring during an electrical component installation, which resulted in arcing and smoke in the cockpit. Contributing to the outcome was the flight instructor's failure to attain a proper descent rate…NTSB GAA17CA465Accident · No injuriesData collectionFinal reportCzech Aircraft Works Spol Sro Sportcruiser · Salisbury, NCThe physical interference of the student pilot’s headset control unit with the canopy, which prevented the canopy latches from seating properly and resulted in the canopy opening in flight and the subsequent hard landing.NTSB ERA17LA215Accident · Serious injuriesLimited investigationFinal reportBeech B23 · Ocean Isle Beach, NCThe pilot's improper positioning of the fuel selector between the left and right fuel tank positions, which resulted in a partial loss of engine power due to fuel starvation and a subsequent forced landing into trees.NTSB ERA17TA196Accident · No injuriesFinal reportErnest T Christley Zenith Zodiac 601XL · Sanford, NCThe pilot’s selection of a threaded metal rod of insufficient strength to connect the fuel tank selector handle to the fuel valve, which resulted in his inability to switch fuel tanks and a subsequent total loss of engine power due to fuel starvation.NTSB ERA16LA301Accident · Minor injuriesLimited investigationFinal reportMeans Rober C Rotorway Exec · Iron Station, NCThe pilot’s failure to maintain adequate clearance from the ground while hovering, which resulted in separation of the forward section of the right skid tube with counterweight attached, a sudden center of gravity (CG) shift outside the normal operating…NTSB ERA16LA162Accident · Minor injuriesClass 3 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2008 · Burgaw, NCThe pilot’s failure to activate the airplane’s alternator, which resulted in an eventual loss of electrical power to the engine’s fuel pumps, fuel starvation, and a total loss of engine power. Contributing was the pilot’s use of an incomplete checklist.NTSB ERA16FA108Accident · 1 fatalField investigationFinal reportBeech A36 · Marshville, NCThe pilot's improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. Contributing to the severity of the pilot's injuries was his failure to have a properly secured shoulder harness at the time of the accident.NTSB ERA16LA085Accident · No injuriesClass 3 · LimitedFinal reportCirrus SR22 · Concord, NCThe pilot’s inadequate management of the airplane’s automated systems, which resulted in a loss of control during an instrument approach and necessitated his subsequent deployment of the airplane’s parachute system.NTSB ERA16CA011Accident · No injuriesData collectionFinal reportPiper PA-32RT-300T · Salisbury, NCThe pilot's inadvertent switching of the fuel selector to the "off" position on final approach, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA15LA358Accident · Serious injuriesLimited investigationFinal reportBellanca 7KCAB · Manteo, NCThe inadvertent lodging of the banner-tow cable between the right elevator and horizontal stabilizer after the pilot threw the grapple hook out the window, which resulted in the loss of pitch control and the airplane’s subsequent impact with water.NTSB ERA15CA321Accident · Serious injuriesData collectionFinal reportQuicksilver MXL II Sport · Pittsboro, NCThe pilot's failure to open the fuel shutoff valve during the preflight examination of the airplane which resulted in a total loss of engine power during initial climb after takeoff due to fuel starvation.NTSB ERA15LA273Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Wilmington, NCThe pilot's failure to ensure that the landing gear was in the down and locked position before touchdown, which resulted in a landing with the gear in transit.