NTSB investigations
19,222 cases where NTSB found Aircraft.
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\", '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."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 ANC23LA082Accident · No injuriesClass 4 · LimitedFinal reportHelio H-295 · Fairbanks, AKThe pilot’s encounter with windshear during initial climb out, which resulted in a loss of control.NTSB ANC23LA078Accident · No injuriesClass 3 · LimitedFinal reportRhodes Steven D SR3500 · Nenana, AKA total loss of engine power due to fuel starvation. Contributing was the owner/builder’s inadequate maintenance.NTSB WPR23LA346Accident · Minor injuriesClass 4 · LimitedFinal reportAeronca 11AC · Apple, IDFuel starvation due to the pilot’s incorrect movement of the fuel selector valve to OFF, which resulted in a loss of engine power.NTSB ANC23LA083Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · McGrath, AKThe pilot’s failure to maintain directional control during after encountering a wind gust during landing that resulted in an impact with terrain.NTSB WPR23FA344Accident · 1 fatalClass 3 · FieldFinal reportSeawind 3000 · Bellevue, WAThe pilot’s loss of airplane control after encountering a lake swell and skipping during takeoff.NTSB CEN23LA411Accident · Serious injuriesClass 4 · LimitedFinal reportRans S6 · LIberty, MOThe inflight fire and impact with terrain for reasons that could not be determined due to extensive fire damage.NTSB ERA23LA374Accident · No injuriesClass 4 · LimitedFinal reportCessna 305 · Cortland, NYThe pilot's failure to maintain directional control while landing in a gusting crosswind, which resulted in a noseover. Contributing was the pilot’s lack of familiarity with the airplane.NTSB ERA23LA372Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182P · Prospect, TNA loss of engine power due to the fatigue failure of the No. 6 cylinder exhaust valve rocker boss.NTSB ERA23LA371Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150G · Cross Keys, NJThe pilot’s failure to maintain adequate airspeed during the banner pickup, which resulted in a low altitude aerodynamic stall/spin.NTSB ERA23LA369Accident · No injuriesClass 3 · LimitedFinal reportEurocopter Deutschland EC135T2 · Fargo, GAThe separation of the outer span of a tail rotor blade during flight as a result of localized intergranular corrosion due to a diminished protective coating at a critical location on the tail rotor blade surface that, combined with cyclic loading, resulted in…NTSB ERA23FA370Accident · 1 fatalClass 3 · FieldFinal reportErcoupe 415 · Fitzgerald, GAThe pilot’s failure to perform pre-takeoff engine runup and carburetor heat check procedures, which resulted in rotation with inadequate climb performance, and his subsequent failure to maintain adequate airspeed and exceedance of the airplane’s critical…NTSB CEN23LA430Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · West Bend, WIThe pilot’s inadequate landing flare that resulted in a hard landing and impact with the runway.NTSB ANC23LA077Accident · No injuriesClass 4 · LimitedFinal reportTaylorcraft BC12-D · Palmer, AKThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering at low altitude, which resulted in an aerodynamic stall; loss of airplane control; and impact with terrain.NTSB ANC23FA074Accident · 1 fatalClass 2 · FieldFinal reportPiper PA-18-150 · St. Mary's, AKThe pilot’s decision to operate the airplane above its maximum certificated gross weight, and his installation of an unapproved external load that degraded takeoff performance and flight characteristics resulting in a loss of airplane control during takeoff…NTSB ANC23LA075Accident · No injuriesClass 4 · LimitedFinal reportCessna 185 · Healy, AKThe pilot’s selection of an unsuitable landing site, resulting in a nose over.NTSB CEN23LA415Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-300 · Moberly, MOThe flight instructor’s inadequate fuel management that resulted in fuel starvation and a total loss of engine power during an approach for landing.NTSB CEN23LA414Accident · Minor injuriesClass 4 · LimitedFinal reportBuckeye Dream Machine · Fortuna, MOThe non-certificated pilot’s failure to maintain the unregistered powered parachute’s clearance from power lines.NTSB ANC23LA081Accident · Serious injuriesClass 4 · LimitedFinal reportPiper/Gerbi Charles R PA 18-150 · Juneau, AKThe student pilot’s failure to maintain altitude after the airplane encountered a downdraft while maneuvering over an area of hilly terrain.NTSB WPR23LA338Accident · Serious injuriesClass 3 · LimitedFinal reportBell 212 · Balch Camp, CAThe pilot’s inadequate performance planning for the operation that resulted in an excessive gross weight for the operating conditions, leading to a loss of altitude during maneuvering and contact with trees. Contributing to the accident was the pilot’s…NTSB CEN23FA410Accident · 1 fatalClass 3 · FieldFinal reportSonex Sonex · Dowagiac, MIThe total loss of engine power due to the failure of the ignition distributor rotor.NTSB ANC23LA073Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Beluga, AKThe pilot’s delayed go-around decision with insufficient runway remaining.NTSB WPR23LA341Accident · No injuriesClass 3 · LimitedFinal reportBellanca 7ECA · El Cajon, CAA total loss of engine power for undetermined reasons.NTSB WPR23LA339Accident · No injuriesClass 4 · LimitedFinal reportEurocopter France AS350B2 · Silverton, WAThe pilot’s failure to maintain visual reference and altitude while maneuvering over a lake during dusk conditions, which resulted in the helicopter impacting water.NTSB CEN23LA406Accident · Serious injuriesClass 4 · LimitedFinal reportBeech B200 · Elk Grove Village, ILThe pilot’s improper fuel planning, that resulted in a total loss of engine power due to fuel exhaustion, and a subsequent forced landing. Also causal was the pilot’s decision to go around with minimum fuel.NTSB WPR23LA355Accident · No injuriesClass 4 · LimitedFinal reportAmerican Champion 7GCBC · Woodland, CAThe pilot’s failure to maintain directional control during the landing roll, which resulted in a ground loop.NTSB ERA23LA364Accident · No injuriesClass 4 · LimitedFinal reportPiper PA24 · Norwood, MAThe pilot’s failure to fly an appropriate glide path during the landing approach, which resulted in a collision with approach lights and the ground short of the intended runway.NTSB CEN23LA405Accident · No injuriesClass 3 · LimitedFinal reportAlisport Silent 2 Electro · Giddings, TXThe glider’s encounter with flutter during cruise flight that resulted in structural damage to the fuselage.NTSB CEN23LA404Accident · No injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Helicopter 369E · Arcola, TXThe instructor’s failure to re-apply engine power during a power recovery after a practice autorotation which resulted in a hard landing.NTSB WPR23LA342Accident · No injuriesClass 4 · LimitedFinal reportCessna T210H · Santa Rosa, CAThe pilot’s failure to configure the landing gear during the landing approach.NTSB ERA23LA388Accident · No injuriesClass 3 · LimitedFinal reportRemos GX · Fort Pierce, FLThe pilot’s inadequate fuel planning, which resulted in a total loss of engine power during cruise flight due to fuel exhaustion.NTSB CEN23FA401Accident · 2 fatalClass 3 · FieldFinal reportCessna 150K · Huntsville, TXA partial loss of engine power due to fuel starvation caused by a fuel system blockage, and the flight instructor’s subsequent failure to maintain adequate airspeed after the loss of engine power, which resulted in the airplane exceeding its critical angle of…NTSB WPR23LA340Accident · No injuriesClass 3 · LimitedFinal reportRutan Long-EZ · Bullhead City, AZThe pilot’s improper flair resulting in a hard landing.NTSB WPR23LA335Accident · No injuriesClass 4 · LimitedFinal reportCessna 150M · Marble Canyon, AZThe pilot’s loss of airplane control after an encounter with windshear during takeoff which resulted in collision with terrain.NTSB CEN23LA402Accident · No injuriesClass 3 · LimitedFinal reportVans RV14 · Orchard, TXThe failure of an alternator belt and the builder/previous owner’s incorrect electrical wiring of the airplane’s other alternator, which resulted in a total loss of electrical and engine power.NTSB CEN23LA398Accident · Minor injuriesClass 3 · LimitedFinal reportVan's RV-12 · Crystal, MNThe pilot’s improper landing flare, which resulted in a bounced landing and an overstress fracture of the nose landing gear strut.NTSB CEN23LA397Accident · Serious injuriesClass 4 · LimitedFinal reportTitanium Auto Gyro Titanium Explorer · Falcon, COThe pilot’s failure to establish a proper airspeed before becoming airborne, which resulted in an inability to climb out of ground effect and subsequent hard landing. Contributing to the accident was high-density altitude.NTSB WPR23LA336Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-18-135 · Compton, CAAn overstress fracture of the pilot’s seat, which resulted in the loss of control during takeoff and the pilot’s inadvertent movement of the fuel selector and subsequent partial loss of engine power.NTSB ERA23LA391Accident · Minor injuriesClass 4 · LimitedFinal reportBalloon Works Firefly 7 · Anderson, SCThe pilot’s failure to avoid trees during the descent for landing, resulting in substantial damage to the balloon.NTSB ERA23LA389Accident · No injuriesClass 4 · LimitedFinal reportBellanca 17-30A · Baltimore, MDThe pilot’s failure to maintain control of the airplane during the aborted landing, which resulted in a collision with a taxiway light.NTSB ERA23FA358Accident · 1 fatalClass 3 · FieldFinal reportCirrus SR20 · Toms River, NJThe pilot's failure to maintain a positive climb rate after takeoff due to spatial disorientation (somatogravic illusion), which resulted in impact with trees and terrain.NTSB CEN23LA400Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Eden Prairie, MNThe pilot’s failure to maintain directional control during a landing with a left crosswind.NTSB CEN23LA396Accident · No injuriesClass 4 · LimitedFinal reportCessna 172G · Neola, IAThe pilot’s inadequate fuel planning and improper in-flight decision-making, which resulted in a total loss of engine power due to fuel exhaustion.NTSB ANC23LA069Accident · No injuriesClass 4 · LimitedFinal reportBellanca 8GCBC · Cordova, AKThe pilot’s exceedance of the airplane’s critical angle of attack during landing, which resulted in an aerodynamic stall and loss of airplane control.NTSB WPR23LA334Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Prescott, AZThe pilot-in-command’s inadequate preflight planning for the high density altitude and relative humidity conditions and his failure to recognize the need to reject the takeoff, allowing the student pilot to execute an abnormally long takeoff roll and apply…NTSB ERA23LA362Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32 · Cincinnati, OHA loss of engine power for reasons that could not be determined.NTSB ERA23LA361Accident · No injuriesClass 3 · LimitedFinal reportBeech V35 · Rutledge, TNA total loss of engine power due to the fatigue failure of a retaining circlip in one of the No. 2 crankshaft cheek counterweights, which resulted in liberation of the counterweight.NTSB WPR23LA333Accident · No injuriesClass 4 · LimitedFinal reportAyres S2R-T34 · Three Rocks, CAThe airplane’s exceedance of the critical angle of attack, resulting in an aerodynamic stall and impact with terrain.NTSB ERA23LA360Accident · No injuriesClass 3 · LimitedFinal reportBrown Benjamin C Challenger II · Moultonborough, NHA loss of engine power due to a loss of compression in one of the engine’s two cylinders.NTSB CEN23LA399Accident · No injuriesClass 3 · LimitedFinal reportBeech 35-B33 · Ava, MOA loss of engine oil due for undetermined reasons, which resulted in failed connecting rods and total loss of engine power.NTSB CEN23LA393Accident · No injuriesClass 4 · LimitedFinal reportCessna R172K · Plover, WIThe pilot’s inadequate fuel management which resulted in a total loss of engine power due to fuel starvation.