NTSB investigations
19,008 cases where NTSB found Personnel issues.
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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '02')) 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '02')) 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 CEN23LA080Accident · No injuriesClass 4 · LimitedFinal reportBeech G33 · Bolingbrook, ILThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA23LA168Accident · No injuriesClass 4 · LimitedFinal reportWeiss Theodore T RV-8 · Ridgeland, SCThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR23LA086Accident · Serious injuriesClass 3 · LimitedFinal reportQuad City Challenger · Kent, WAThe pilot’s inflight loss of airplane control. Contributing to the accident was the pilot’s decision to fly the airplane without receiving training in its operation and flight characteristics.NTSB ERA23FA103Accident · 2 fatalClass 3 · FieldFinal reportPiper PA28 · Suffolk, VAThe pilot’s decision to fly the airplane without confirming it had been released from maintenance, which resulted in a partial loss of engine power due to loose magnetos. Contributing to the outcome was the pilot’s failure to maintain adequate airspeed and…NTSB CEN23FA074Accident · 1 fatalClass 3 · FieldFinal reportBeech M35 · Fayetteville, ARThe pilot’s mismanagement of the airplane’s fuel system, which resulted in fuel starvation and a loss of engine power.NTSB ERA23LA105Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Paris, KYThe pilot’s loss of control after encountering changing wind conditions during the initial climb, which resulted in descent and collision with terrain.NTSB ERA23LA102Accident · No injuriesClass 4 · LimitedFinal reportStray Goose Research Aircam · Calhoun, GAThe pilot’s inadvertent asymmetric throttle application, which resulted in a loss of directional control during the landing roll, runway excursion, and collision with ground equipment.NTSB WPR23FA083Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-34-220T · New Harmony, UTThe pilot’s decision to continue visual flight rules flight into instrument meteorological conditions, which resulted in a loss of airplane control due to spatial disorientation.NTSB ERA23LA104Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Opa-locka, FLThe flight instructor’s decision to taxi behind a large multi-engine airplane, which resulted in an encounter with propeller blast and a loss of airplane control on the ground.NTSB CEN23LA075Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Yukon, OKThe pilot’s failure to maintain directional control during the landing roll.NTSB WPR23FA080Accident · 1 fatalClass 3 · FieldFinal reportEmbraer Executive EMB-505 · Provo, UTThe pilot’s failure to deice the airplane before takeoff in weather conditions conducive to ice accumulation, which resulted in an ice-contaminated wing and subsequent stall during takeoff.NTSB DCA23LA114Accident · No injuriesClass 4 · LimitedFinal reportBombardier CL-600-2D24 · New York, NYITA Airways flight crew's incorrect evaluation of the clearance between their airplane and another airplane stopped on an adjoining taxiway.NTSB ANC23LA011Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Kenai, AKThe pilot's failure to maintain directional control during landing in flat light conditions, resulting in the airplane to nose over.NTSB WPR23LA082Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Watsonville, CAThe pilot’s failure to maintain clearance from powerlines during a go around.NTSB ERA23LA107Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-301T · Old Bridge, NJThe pilot’s failure to maintain adequate clearance from trees during the landing approach.NTSB CEN23LA073Accident · No injuriesClass 4 · LimitedFinal reportCessna 172K · Conway, ARThe solo student pilot’s improper landing flare and subsequent improper recovery from a bounced landing.NTSB DCA23LA109Accident · 1 fatalClass 3 · LimitedFinal reportEmbraer S A ERJ 170-200 LR · Montgomery, ALThe ramp agent’s cognitive impairment, which resulted in her (1) inconsistent behavior with trained procedures and pre landing briefings, (2) presence on the left side of the airplane while the left engine was still operating, and (3) subsequent ingestion…NTSB ERA23LA097Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA24 · Athens, GAThe pilot’s failure to detect water in the fuel during the preflight inspection, which resulted in a loss of engine power.NTSB CEN23FA071Accident · 4 fatalClass 3 · FieldFinal reportBell 407 · Galliano, LAThe pilot’s failure to ensure the helicopter was clear of obstacles before takeoff from the helideck, which resulted in the helicopter’s right landing skid pivoting about a helideck perimeter light during takeoff and a dynamic rollover. Additionally, the…NTSB WPR23LA081Accident · No injuriesClass 4 · LimitedFinal reportEmbraer Executive EMB-505 · Hawthorne, CAA runway overrun due to the pilot’s failure to stop the airplane as a result of diminished braking action due to a water contaminated runway surface.NTSB ERA23LA098Accident · No injuriesClass 4 · LimitedFinal reportCessna 182P · Ethel, WVThe pilot’s failure to maintain directional control during landing, which resulted in a runway excursion.NTSB CEN23LA072Accident · No injuriesClass 4 · LimitedFinal reportPiper PA46 · Brookshire, TXThe P51 pilot’s failure to see and avoid the PA46 during taxi operations.NTSB WPR23LA075Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 8GCBC · Payson, AZThe pilot’s loss of directional control during the landing roll, which resulted in a runway excursion.NTSB ERA23LA095Accident · No injuriesClass 4 · LimitedFinal reportBellanca 7ECA · Hampton, NHThe pilot’s failure to maintain directional control of the airplane while landing in crosswind conditions, which resulted in a runway excursion.NTSB ERA23LA094Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 177 · Franklin, VAThe pilot’s failure to maintain clearance from trees during the initial climb following an aborted precautionary landing. Contributing to the outcome were the inoperative runway lights, which reduced the likelihood that the pilot could successfully land the…NTSB CEN23LA069Accident · No injuriesClass 4 · LimitedFinal reportCessna 150J · South St. Paul, MNThe student pilot’s failure to maintain directional control during the take-off roll with a snow and ice covered runway.NTSB WPR23LA077Accident · Serious injuriesClass 3 · LimitedFinal reportBeech V35B · Livermore, CAThe pilot’s inadvertent use of the mixture control instead of the throttle, which resulted in fuel starvation and the subsequent loss of engine power.NTSB CEN23LA068Accident · No injuriesClass 3 · LimitedFinal reportGrumman American AA-5B · Reserve, LAThe partial loss of engine power due to carburetor icing and the flight instructor’s failure to use carburetor heat in weather conditions conducive to serious carburetor icing.NTSB CEN23LA067Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172F · Auburn Hills, MIThe catastrophic engine failure due to lack of oil lubrication, which resulted from the pilot’s failure to follow the airplane and engine manufacturers’ guidance for cold weather operation.NTSB CEN23LA091Accident · No injuriesClass 4 · LimitedFinal reportCessna 150G · Pocahantas, IAThe pilot’s landing flare which resulted in a bounced landing and the nose landing gear collapsing. Contributing to the accident was the airplane's encounter with adverse weather conditions which led to structural icing that affected flight characteristics…NTSB WPR23LA085Accident · Minor injuriesClass 4 · LimitedFinal reportAuto-Gyro Cavalon · Benson, AZA loss of directional control on takeoff, which resulted in the collapse of the nose wheel strut and a runway excursion.NTSB DCA23LA172Incident · No injuriesClass 4 · LimitedFinal reportBoeing 777 · Kahului, HIThe flight crew’s failure to manage the airplane’s vertical flightpath, airspeed, and pitch attitude following a miscommunication about the captain’s desired flap setting during the initial climb.NTSB WPR23LA071Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · San Manual, AZThe pilot’s failure to maintain directional control during landing which, resulted in a runway excursion.NTSB WPR23LA070Accident · Minor injuriesClass 4 · LimitedFinal reportVans RV6 · Afton, WYThe pilot’s failure to maintain control during landing on a contaminated runway.NTSB DCA23LA096Accident · Serious injuriesClass 3 · LimitedFinal reportAirbus A330-243 · Kahului, HIThe flight crew’s decision to fly over an observed storm cell instead of deviating around it despite sufficient meteorological information indicating the potential for severe convective activity.NTSB WPR23LA074Accident · Minor injuriesClass 4 · LimitedFinal reportRoyse Ralph L Glasair · Cottonwood, CAThe pilot’s fuel mismanagement which resulted in fuel starvation and a total loss of engine power.NTSB ERA23LA091Accident · Minor injuriesClass 3 · LimitedFinal reportCessna R172K · Brooksville, FLA hard landing that fractured the nose landing gear assembly, resulting in a loss of directional control and a nose-over.NTSB WPR23LA100Accident · No injuriesClass 4 · LimitedFinal reportAeronca 65-CA · Deming, NMThe occupant’s improper throttle movement during the start procedure, which resulted in forward movement and loss of airplane control.NTSB CEN23LA065Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Denton, TXThe pilot’s failure to maintain clearance from another airplane while taxing in the run-up area.NTSB CEN23LA064Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206-L4 · Gulf of Mexico (Gulf of Mexico)The pilot’s improper takeoff technique that allowed the helicopter skid to drift into a helideck light, resulting in a dynamic rollover.NTSB ANC23FA008Accident · 3 fatalClass 3 · FieldFinal reportRaytheon C90A · Kaupo, HIGuardian Flight’s inadequate pilot training and performance tracking, which failed to identify and correct the pilot’s consistent lack of skill, and which resulted in the pilot’s inability to maintain his position inflight using secondary instruments to…NTSB ERA23LA090Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22 · San Juan, PRThe pilot’s improper recovery from a bounced landing which resulted in a loss of control and subsequent runway excursion.NTSB WPR23LA072Accident · No injuriesClass 4 · LimitedFinal reportCessna 441 · Liberal, KSThe pilot’s inadequate preflight inspection, failure to set the parking brake, and his decision to exit the airplane with engines running to remove a wheel chock, resulting in the airplane’s unintended movement and subsequent collision with a hangar.NTSB WPR23LA065Accident · No injuriesClass 4 · LimitedFinal reportPiper PA42 · Lewistown, MTThe pilot’s improper landing flare, which resulted in a hard landing. Contributing to the accident was the out of service visual glideslope indicator and snow obscuring the runway markings.NTSB ERA23LA089Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-38-112 · Rockingham, NCThe pilot’s improper fuel management, which resulted in fuel exhaustion and a total loss of engine power.NTSB ERA23FA087Accident · 1 fatalClass 3 · FieldFinal reportMooney M20B · Kellyton, ALA total loss of engine power due to fuel starvation.NTSB ERA23LA085Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Knoxville, TNThe pilot’s loss of directional control during engine start.NTSB WPR23LA068Accident · No injuriesClass 4 · LimitedFinal reportEurocopter EC120B · Rancho Cordova, CAThe pilot receiving instruction’s loss of helicopter control during landing with a crosswind, and the flight instructor’s delayed remedial action.NTSB ERA23LA084Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 Beta · Gilgo-Oak Beach-Captree, NYThe flight instructor’s inadequate remedial action while supervising the student pilot’s practice autorotation in gusting wind conditions, which resulted in a dynamic rollover.NTSB WPR23LA062Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Socorro, NMThe pilot’s improper landing flare, which resulted in a hard bounced landing and loss of control in gusting wind.