NTSB investigations
902 cases where the first occurrence was “Miscellaneous/other”.
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\" = 430) 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" = 430) 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 NYC91LA065Accident · No injuriesLimited investigationFinal reportPiper PA-32-301 · Celina, OHThe pilot-in-command's improper use of the powerplant controls, magnetos and brakes.NTSB DEN91LA036Accident · 1 fatalLimited investigationFinal reportCessna 180K · Patterson, LAThe pilot's failure to identify an unsafe or hazardous condition. Factors were: rough water and high winds.NTSB SEA91LA034Accident · 1 fatalLimited investigationFinal reportBeech D50C · Snohomish, WAThe obstruction (protruding door support bracket) in the doorway of the aircraft; failure of the company/operator personnel, the pilot, and the skydivers to assure that the doorway was clear of obstructions; and subsequent snagging of the d-ring, which…NTSB MIA91LA040Accident · No injuriesLimited investigationFinal reportBell 206B · Fort Pierce, FLThe incorrect cyclic control input by the student during the touchdown autorotation landing and failure of the CFI to correct this before the helicopter touched down.NTSB CHI91IA041Incident · No injuriesIncident investigationFinal reportBoeing 727-257 · Detroit, MIThe inadequate deicing procedures instituted by company management.NTSB MIA91LA027Accident · 2 fatalLimited investigationFinal reportCessna 172P · Atlantic Ocean (Atlantic Ocean)Delay of the pilot to obtain assistance and, as a result, he ditched the airplane near a boat due to a low fuel supply.NTSB ATL91FA008Accident · 2 fatalField investigationFinal reportBeech A36 · Georgetown, SCThe pilot-in-command's loss of consciousness during flight. The reason for the loss of consciousness could not be determined.NTSB LAX91LA024Accident · No injuriesLimited investigationFinal reportCessna 152 · Watsonville, CAThe failure of the pilots of both aircraft to see and avoid the other.NTSB CHI90DEC05Accident · No injuriesFinal reportSchleicher ASW-22 · Richmond, MIThe pilot's premature retraction of the flaps allowing the glider to settle into an unusually low tow altitude.NTSB DCA90IA048Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-211 · Chicago, ILThe pilot(s) allowed the aircraft to rotate to an excessive nose high attitude, either during a takeoff or landing.NTSB LAX90LA270Accident · No injuriesLimited investigationFinal reportCessna 172G · Trinity Center, CAThe pilot's excessive airspeed and his failure to touchdown at the proper location on the runway.NTSB SEA90LA156Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas DC-10-10 · Coeur D'Alene, IDPassenger spilling a hot cup of coffee in her lap while the flight was in cruise flight.NTSB BFO90DIG02Accident · Minor injuriesFinal reportCessna 182J · Frederick, MDFailure of the pilot to assure that the magneto (ignition) switch was in the proper position. A factor related to the accident was: partial failure of the magneto switch, which allowed the key to be removed, though the switch was not in the 'off' position.NTSB ATL90FA150Accident · 1 fatalField investigationFinal reportPiper PA-18A · Conway, SCTowline interference with the rudder, and failure of the pilot to maintain adequate airspeed, which resulted in a stall/spinn. A factor that contributed to the accident was: failure of the company/operator management to adequately guard against such…NTSB LAX90FA250Accident · Serious injuriesField investigationFinal reportPiper PA-25-235 · Pleasant Valley, AZAn inadvertent spin after failure to maintain airspeed. Factors include inadequate preflight, and an improperly maintained lap belt.NTSB FTW90LA133Accident · 1 fatalLimited investigationFinal reportBell 206B · San Antonio, TXThe lineman/flight crewman not following procedures.NTSB MIA90LA147Accident · No injuriesLimited investigationFinal reportCessna 150F · Pensacola, FLInstructor pilots failure to assure that the flaps were in the proper position for takeoff resulting in reduced climb performance. This resulted in the forced landing, during which, the airplane collided with a power line, stalled, then crashed to the ground.NTSB LAX90LA225Accident · No injuriesLimited investigationFinal reportBellanca BL26 · Santa Ana, CAThe pilot's use of an improper starting technique.NTSB NYC90LA124Accident · Minor injuriesLimited investigationFinal reportBurkhart Grob G103 · Barre, MAThe premature commanded tow release by the towplane pilot over unsuitable terrain.NTSB ANC90LA078Accident · No injuriesLimited investigationFinal reportChampion Aeronca 7DC · Elmendorf, AKFailure of the pilot to properly tie down and chock the aircraft and/or obtain proper assistance, and his failure to properly set the throttle, while hand propping to start the engine.NTSB CHI90LA134Accident · No injuriesLimited investigationFinal reportCessna 172N · Jeffersonville, INThe engine started for an undetermined reason, when the prop was moved after the pilot experienced an inoperative starter. (Most probably, there was either an isolated/intermittent problem in the ignition system or the pilot did not move the magneto switch…NTSB MIA90LA123Accident · Serious injuriesLimited investigationFinal reportBell TH-13T · Biloxi, MSThe passenger's intentional act of jumping in the air with his arm raised while under the main rotor.NTSB LAX90LA189Accident · Serious injuriesLimited investigationFinal reportMcDonnell Douglas 369E · Hilo, HIImproper supervision and absence of assistance by the company to passengers disembarking the helicopter.NTSB MIA90LA110Accident · No injuriesLimited investigationFinal reportCessna 180K · Crystal Springs, MSPilots failure to assure that the fuel cap was in position and secured prior to departure. This resulted in fuel siphoning overboard resulting in the precautionary landing.NTSB ATL90LA083Accident · Minor injuriesLimited investigationFinal reportCessna 172G · Gulf Shores, ALFailure of the pilot to obtain proper assistance or properly secure the aircraft when he left it unattended with the engine running.NTSB MKC90LA066Accident · Minor injuriesLimited investigationFinal reportBeech A23 · Fordyce, ARThe passenger's intentional interference with the flight by seizing the controls and shutting off the engine.NTSB MIA90LA076Accident · No injuriesLimited investigationFinal reportHughes 300C · Vero Beach, FLThe failure of the pilot in command/instructor pilot to maintain adequate rotor RPM after landing from a touchdown autorotation. A factor related to the accident was the gusty wind condition.NTSB DCA90MA019Accident · 73 fatalClass 1 · MajorFinal reportBoeing 707-321B · Cove Neck, NYThe failure of the flightcrew to adequately manage the airplane's fuel load, and their failure to communicate an emergency fuel situation to air traffic control before fuel exhaustion occurred. Contributing to the accident was the flightcrew's failure to use…NTSB NYC90IA050Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-51 · Philadelphia, PAThe flight crew of EAL121 taking off on a taxiway. Contributing was failure of the flight crew of eal 121 to maintain an adequate visual lookout during taxi and takeoff.NTSB NYC90LA046Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Kutztown, PAImproper decision of the glider pilot to exit the glider without positive assurance that the tow pilot had received his signal or that the glider was released from the tow plane. A related factor to the accident was: the lack of crew coordination between the…NTSB MIA90LA042Accident · 1 fatalLimited investigationFinal reportBoeing 727-225B · Miami, FLFatal injury to a stowaway due to asphyxia and hypothermia.NTSB MIA90IA038Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-51 · Tallahassee, FLFailure of the first officer to properly align the aircraft for landing, and the captain's delay in taking remedial action.NTSB CHI90LA038Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12D · Millbury, OHFailure of the pilot to properly secure the aircraft and/or adequately brief the passenger (student pilot), and inadvertent bumping of the throttle by the passenger.NTSB LAX90LA033Accident · 1 fatalLimited investigationFinal reportMcDonnell Douglas 369 · Barstow, CAImproper planning/decision by the pilot, and his delay in jettisoning the load.NTSB BFO90LA015Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Ocean City, NJFailure of the pilot to obtain proper assistance or properly secure (tie down/chock) the aircraft.NTSB LAX90LA021Accident · Serious injuriesLimited investigationFinal reportBoeing 757-2S7 · Phoenix, AZThe ground handler improperly crossing under the aircraft while it was moving.NTSB ATL90LA025Accident · No injuriesLimited investigationFinal reportCessna 152 · Dyersburg, TNPilot's temporary physical condition (possible hyperventilation or anxiety attack). Soft terrain in the emergency landing area was considered to be a related factor.NTSB CHI90LA020Accident · No injuriesLimited investigationFinal reportBell 47G-2A-1 · Plymouth, INThe student's improper use of the cyclic control and the instructor's (cfi's) inadequate supervision.NTSB LAX90LA036Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Ontario, CAImproper use of the brakes by the pilot of the Piper PA-31.NTSB SEA90LA004Accident · No injuriesLimited investigationFinal reportCessna 310C · Redmond, ORPoor inflight planning, and the pilot did not maintain a proper glide path on final approach, nor perform proper corrective action. Factors related to the accident were: the pilot's attention was diverted due to an open cabin door and the partial loss of…NTSB LAX90LA006Accident · No injuriesLimited investigationFinal reportPiper J-2 · Santa Ynez, CAFailure of the pilot to adequately secure the aircraft before hand propping the engine.NTSB ANC89LA180Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Windy Fork, AKImproper planning/decision by the pilot.NTSB MIA89IA248Incident · No injuriesIncident investigationFinal reportBoeing 757-232 · Fort Lauderdale, FLImproper use of the elevator control.NTSB CHI89DEM08Accident · No injuriesFinal reportMooney M20 · West Branch, MIThe pilot's decision to hand prop the engine with a non-pilot at the controls and the passenger's application to full throttle. A factor related to the accident was panic of the passenger.NTSB CHI89IA180Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas MD-80 · Chicago, ILThe failure of the controller to clarify the confusing communications, to correct the pilot's misinterpretation of the instructions being given, and the failure of the supervisor to properly monitor the situation. Factors related to the incident were the…NTSB LAX89LA291Accident · Minor injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Hemet, CAInadequate crew coordination between the tow pilot and glider pilot, failure of the glider pilot to obtain proper assistance, and the tow pilot's misunderstanding of the glider pilot's intentions.NTSB CHI89LA176Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Eau Claire, WIInadvertent retraction of the landing gear by the pilot. His habit interference and lack of experience in the type of aircraft were contributing factors.NTSB BFO89LA077Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-65 · Leonardtown, MDInadequate preflight planning/preparation by the pilot by not assuring that the acft was properly secured, or that someone was at the controls while he was hand propping the engine. A related factor was the pilot's improper adjustment of the throttle cable.NTSB BFO89LA076Accident · No injuriesLimited investigationFinal reportCessna 150 · Gaithersburg, MDAn undetermined problem with the ignition system. A factor related to the accident was: the pilot's failure to properly secure the airplane or obtain proper assistance.NTSB MKC89LA186Accident · No injuriesLimited investigationFinal reportCessna 172 · Clear Lake, MNThe pilot's improper decision in attempting to land with inadequate visual cues which precluded identification of a correct runway alignment. A suitable alternative airport was readily available.