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 NYC88LA142Accident · Serious injuriesLimited investigationFinal reportBalloon Works Firefly 7 · Red Creek, NYWhile the pilot was waiting for liftoff, three ground crewmen were sitting on the basket holding the Balloon down. As the pilot prepared for liftoff, he announced that he was ready for liftoff and untied the rope. As the Balloon reached an altitude of about…NTSB CHI88IA111Incident · No injuriesIncident investigationFinal reportBoeing 737-222 · Detroit, MINTSB ATL88LA166Accident · 1 fatalLimited investigationFinal reportPiper J5C · Gulf Shores, ALA witness reported that the airplane encountered a 'downdraft' while attempting to pick up a banner. The main ldg gear caught the banner pick-up line and carried the banner aloft. The witness radioed the plt to advise him of the situation, but received no…NTSB MIA88LA156Accident · 1 fatalLimited investigationFinal reportMooney M-20J · Perry, FLJacksonville center reported a loss of radar contact with the acft at approx 2133 EDT after it descended from its last assigned altitude of 6000 feet. The sole occupant and debris from the acft were found shortly thereafter. The results of an autopsy on the…NTSB CHI88IA097Incident · Minor injuriesIncident investigationFinal reportFairchild SA-226-TC · Bloomington, ILPhysical incapacitation due to an organic pathogen. Contributing factors are anxiety and self-induced pressure.NTSB MIA88FA138Accident · Serious injuriesField investigationFinal reportBoeing 727-224 · Sarasota, FLThe captain of the Boeing 727 aircraft was aware that a refueler was utilizing known quantity refueling procedures due to an inoperative fuel guage. He allowed the flight engineer to activate the b hydraulic system and the ground interconnect switch, without…NTSB LAX88LA147Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Apple Valley, CADrg a flt from hawthorne to delano, CA, the plt became lost, saw an arpt & landed. After landing, she learned she was at the depue arpt, lenwood, CA. No fuel was available, so she elected to fly to Apple Valley, a distance of about 17 mi. However, before…NTSB NYC88IA112Incident · No injuriesIncident investigationFinal reportBoeing 757 · Providence, RIThe Boeing 757 was climbing through 20000 ft with the first officer on the flight controls when the 55 year old captain became incapacitated. The first officer delcared an emergency and made a normal landing. When clear of the runway, the aircraft was stopped…NTSB NYC88LA111Accident · Minor injuriesLimited investigationFinal reportBeech 23 · Rutland, VTPrior to leaving the aircraft to hand prop the engine, the pilot checked the throttle setting and set the brakes. He told his passenger (his wife) to pull back on the throttle when the engine started, however she was unable to do so and the aircraft began…NTSB ATL88IA117Incident · No injuriesIncident investigationFinal reportAero Commander 680E · New York, NYThe airplane had been given a daily insp on 03-10-88 with no structural damage noted. During the next daily inspection on 03-14-88, skin buckling was noted on both wings. Three different pilots had flown the airplane between inspections and all indicated that…NTSB ATL88IA113Incident · No injuriesIncident investigationFinal reportCessna 172B · Elizabethton, TNDue to a low charge in the battery, the plt elected to start the eng by hand propping, so he could program the loran for a later flt. He began hand propping with the tail & left wing tied down. After the eng started, the tiedown for the tail pulled loose &…NTSB MKC88LA057Accident · No injuriesLimited investigationFinal reportMorane-Saulnier F1-156C · Pine Bluff, ARThe pilot, while hand-propping the acft for a personal flt, started the engine. The cockpit was unattended. He was assisted by two ground crewmembers that were holding onto the wing struts. After starting, the engine progressively developed more power, and…NTSB DEN88IA072Incident · No injuriesIncident investigationFinal reportDe Havilland DH-7 · Denver, COAs rocky mtn airway flt 2129 (De Havilland DH-7, N9058P) & Cessna 441, N1WB, were arriving, there was moderate to hvy traffic & a rwy change was in progress. N1WB & flt 2129 were provided initial sequencing by feeder ctlrs (AR-1 & AR-4). Both flts were handed…NTSB CHI88IA061Incident · No injuriesIncident investigationFinal reportDouglas DC-10 · Chicago, ILJudgemental error on the part of the local controller for clearing vehicles across the active runway tiwh insufficient separation from arriving aircraft, which was further compromised by a mechanical malfunction in the equipment crossing the runway.NTSB BFO88LA017Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Petersburg, VAThe plt hand-propped the engine when he was unable to start it using the starter. The acft had just been refueled and it was standing next to the fuel pumps. The plt pushed the acft away from the pumps before he tried to hand-prop it. After the third…NTSB NYC88LA074Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas DC-9-82 · Decatur, MIThe flight attendant was pulling a beverage cart up the aisle when the pad the coffee pot was resting on caught against a curtain. The pad was pulled off the cart and the full pot of coffee spilled in a passengers lap. The passenger service cart has a…NTSB CHI88LA052Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Mankato, MNNTSB FTW88LA050Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas DC-10 · Dfw Airport, TXUnexpected opening of the IL door, which caught the passenger between it and the bulkhead as the door moved inward and upward. A secondary cause was the failure of the flight attendants to follow company procedures requiring them to guard all entry doors…NTSB MIA88LA076Accident · Minor injuriesLimited investigationFinal reportCrusenberry Windwagon · Lantana, FLWhile on a high speed taxi test the acft inadvertently became airborne. While looking out the rt side of the acft the plt rolled it into a rt bank. He then leveled the wings after which the acft stalled, touched down and separated the main landing gear wheels…NTSB CHI88DEV01Accident · 1 fatalFinal reportCessna 150L · Marion, ILPilot in command suffered a fatal heart attack. His wife, a private pilot, attempted to land the aircraft, lost control on landing roll and struck a runway light.NTSB MIA88LA051Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · San Antonio, FLThe student plt became lost while on a solo x-c training flt. He attempted to contact his non control tower destination airport via UNICOM. He stated that he flew around for 20 or 25 mins attempting to make UNICOM contact & was unsuccessful in doing so. He…NTSB LAX88IA064Incident · No injuriesIncident investigationFinal reportBoeing 737-300 · Los Angeles, CADelta flt 1605 landed on rwy 25L. After crossing rwy 25R, the local controller instructed the flt to contact the gnd controller. The ground controller instructed the flt to turn west on the outer taxiway. The capt became disorientated and inadvertently…NTSB LAX88FA057Accident · Serious injuriesField investigationFinal reportBoeing 737-387 · Los Angeles, CAThe Boeing 737-387, N383AU, operating as usair flt 20, a regularly scheduled domestic flight, returned to lax shortly after takeoff, when the capt was advised of a bomb threat. After landing on rwy 24L, the capt parked the airplane on the west end of the rwy.…NTSB MKC88LA016Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Leavenworth, KSWhile practicing landings and takeoffs, the PIC inadvertently put the gear switch in the retract cycle while rolling out. The gear began its retraction cycle with the acft still on the rwy, damaging the retraction system. The plt elected to tkof, but once…NTSB NYC88LA033Accident · No injuriesLimited investigationFinal reportCessna 152 · Groucester Twsp, NJThe student pilot was on a cross country training flight. He stated that the VOR was inoperative but he recognized the VOR by a road that passed near it. The pilot became disoriented and was not able to locate a checkpoint. He descended to 1500 feet, spotted…NTSB NYC88LA020Accident · No injuriesLimited investigationFinal reportAgusta 109A · Spring Valley, NYThe helicopter had been refueled and the pilot was attempting to ground taxi. Prior to turning the aircraft around to taxi to a parking area the helicopter went into ground resonance as soon as the aircraft was moved. Collective was lowered, the engine…NTSB NYC88LA018Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Laconia, NHThe plt rprtd he was demonstrating a full touchdown autorotation in winds that were from 290 deg at 15 gusting 20 KTS. He stated the touchdown was soft with a lot of pitch pulled in; however, as he lowered the collective after touchdown, the retreating blade…NTSB ATL88FA020Accident · 3 fatalField investigationFinal reportBeech B24R · Louisville, KYDrg tkof fm rwy 19, the plt transmitted 'we have a door open.' Twr psnl clrd him to lnd on any rwy, but he stated againthat a door was open. Again, twr psnl clrd him to lnd on any rwy. No otr radio calls were recd fm the acft. Svrl personssaw the acft at low…NTSB BFO88FA003Accident · 1 fatalField investigationFinal reportCessna 172H · Indian Head, MDThe non-certificated plt took the acft without proper authority. A note was found in his automobile that showed he intended to commit suicide. A revolver was found at the crash scene with a spent cartridge under the hammer. Postmortem studies showed the pilot…NTSB NYC88LA006Accident · No injuriesLimited investigationFinal reportCessna 150 · Croghan, NYThe pvt plt & one passenger became disoriented while they were on a x-country pleasure flt. The plt was unable to contact any communication center, so she landed in a field & obtained info to get her bearings. She took off again using short/soft field…NTSB LAX88FA001Accident · 1 fatalField investigationFinal reportCessna 172RG · Calistoga, CAUpon arriving over the destination arpt the plt used an incorrect CTAF frequency to contact the arpt and he used a right hand traffic pattern approaching the 2600 foot-long rwy. Because a residential area lay west of the arpt & open fields lay to the east,…NTSB ATL87FA255Accident · Serious injuriesField investigationFinal reportCessna 402C · Atlanta, GADuring climb to cruise at about 4,000 ft MSL, the plt heard a 'whistling' noise and noticed that the crew door adjacent to his seat was not completely secured. The door came open as he attempted to properly secure it, and yanked his left arm outside the acft.…NTSB NYC87IA258Incident · Minor injuriesIncident investigationFinal reportBeech 99 · Portland, METhe acft was cruising at 2500 ft with no passengers on board. The co-pilot went into the cabin and noticed a loud hissing noise around the main cabin door. He checked the handle and locking pins and noticed the door was locked. He told the captain who…NTSB MIA87IA237Incident · Minor injuriesIncident investigationFinal reportBoeing 727-223 · Tampa, FLDuring descent the B727 crew noted the fire warning light illuminate on the #1 engine. They discharged 2 fire bottles into the engine but the warning light remained illuminated. They declared an emergency and landed at their destination. An emergency…NTSB SEA87LA167Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Juneau, AKDue to a low battery charge, the plt elected to hand prop the acft to start the eng. He rprtd the eng became flooded, so he shut off the mags & opened the throttle, to clear the eng while hand turning the prop. He then turned on the master sw & mags, but…NTSB BFO87FA053Accident · 1 fatalField investigationFinal reportBoeing 747-200B · Washington, DCA flight attendant fell from the acft during opening of the L5 door. The f/a was helping a company ground person, who was outside on the boarding step. The boarding step was not against the acft but about 1 ft away from it. When the door was opened, the f/a…NTSB LAX87LA288Accident · No injuriesLimited investigationFinal reportLuscombe 8A · Selma, CAA Luscombe 8A collided with two parked airplanes after a hand propped start. The student pilot started the aircraft engine without the brakes set, with no chocks, and with no one in the cockpit. Once the engine started, the aircraft subsequently collided with…NTSB NYC87DNE04Accident · 1 fatalFinal reportPiper PA-28-180 · Groton, CTShortly after the aircraft departed the airport, air traffic control personnel received a distress call from the non-pilot rated passenger. She stated that the pilot (her husband) was incapacitated by an apparent heart attack and she was not qualified to fly…NTSB ATL87LA221Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Edmund, SCThe CFI stated that he was having the pre solo student make a crosswind ldg after an hours practice at another apt. The student was using the slip method to correct for the crosswind. Touchdown was with a side load on the gear and the acft bounced. The CFI…NTSB LAX87FA257Accident · 2 fatalField investigationFinal reportBeech A60 · Santa Rosa, CAPilot's failure to maintain adequate airspeed on final approach which resulted inthe aircraft stalling.NTSB ATL87IA201Incident · No injuriesIncident investigationFinal reportBoeing 737-232 · Frankfort, KYThunderstorms and lightning in the vicinity of the arpt prevented adding fuel to the acft and resulted in a delayed departure. The lou VOR was out of service, and the flt was radar vectored until it was cleared direct to lex and for the apch. At the time of…NTSB ATL87IA191Incident · No injuriesIncident investigationFinal reportSwearingen SA-226TC · Nashville, TNThere was hvy traffic at the Nashville metro arpt when air midwest flt 4530 (Swearingen SA-226TC, N256AM) arrived drg a morning flt. The flt crew made an ILS apch to rwy 31 as another acft (American flt 130) was on an apch to rwy 2L. The 2 rwys intersected nr…NTSB SEA87LA109Accident · Minor injuriesLimited investigationFinal reportHughes 269C · Vancouver, WADuring a practice run-on landing the aircraft started to vibrate violently and an almost simultaneous fire occurred. Both pilots and an eyewitness stated that the run on landing was very smooth. Both pilots stated that something mechanical let loose during…NTSB LAX87FA219Accident · Serious injuriesField investigationFinal reportBoeing 727-264 · Los Angeles, CAThe aircraft landed on rwy 25 left and was holding short of 25 right for a crossing clearance when the flight engineer started the APU. Passengers seated in the area between rows 20 and 22 on the right side of the cabin observed a 'bright' yellow blossoming…NTSB CHI87LA136Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Plymouth, INWhile on final approach about 200 feet from the end of the runway, the right front seat passenger told the pilot she thought she saw a deer. The pilot added power for a possible go-around. Since he did not see any deer, the pilot continued his landing. He…NTSB NYC87LA151Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Jeanette, PAThe plt put small chocks under the wheels, then began to hand prop the eng with no one at the controls. The eng started, & before the plt could reach the cockpit, the acft made svrl 360 deg turns & subsequently rolled into trees.NTSB NYC87LA145Accident · No injuriesLimited investigationFinal reportCessna 150 · Stanford, NYDuring enroute flight from rock island, providence to lincoln park, an engine power loss was experienced. In addition the pilot stated that he had become lost and disoriented due to darkness. When the aircraft started to descend, the pilot looked for a spot…NTSB LAX87LA191Accident · Serious injuriesLimited investigationFinal reportBeech 95-55 · Monterey, CAJust after take-off, the cabin door opened in flight. The plt attempted to reland but was unsuccessful due to weather conditions. The plt was vectored to another arpt, however, the plt never climbed to the assigned alt and was never in radar contact. The plt…NTSB NYC87LA168Accident · No injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Sanford, METhe acft was being hand propped from behind the prop on the rgt side when the eng started. The plane jumped the chock, knocked the plt to the ground, turned to the rgt & collided with a parked acft in the tie-down area. The acft was not tied down & only the…NTSB LAX87IA176Incident · No injuriesIncident investigationFinal reportde Havilland DHC-6-300 · Agana (Pacific Ocean)As the aircraft approached its home airport at Agana, guam the captain passed out. The first officer took over the controls and landed the acft without further incident. The cause of the incapacitation was not determined.