NTSB investigations

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

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
  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.

NTSB MKC86LA074Accident · No injuriesLimited investigationFinal reportBeech G18S · Cedar Rapids, IAThe pilot was aware that he would have a strong crosswind on landing. He was landing on runway 13 with winds from 180 degrees at 20 knots, gusting to 30 knots. The pilot stated that while the airplane was rolling down the runway, the right wing was lifted by…Mar 25, 1986 · N528 · Substantial damageNTSB MIA86LA105Accident · No injuriesLimited investigationFinal reportCessna 150L · St. ThomasThe student plt was on a supervised solo flt practicing to & ldgs. On the last ldg, the wind caught the acft & the plt attempted to recover without adding power. Control of the acft was lost & the plt attempted to force the acft back onto the rwy. The acft…Mar 25, 1986 · N11505 · Substantial damageNTSB MIA86LA104Accident · No injuriesLimited investigationFinal reportCessna 210E · Jacksonville, FLAfter departure plt selected landing gear up and did not receive a gear up indication. Another aircraft flew under the aircraft and reported the nose gear and left main gear were up and that the right main gear was partially extended. When attempts to correct…Mar 25, 1986 · N4916U · Substantial damageNTSB LAX86LA154Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Tucson, AZA Cessna 150 collided with terrain during a takeoff from a road. The student plt indicated he was practicing aerial maneuvers in the training area when the engine quit. He successfully accomplished a power off landing to an asphalt road. A certified mechanic…Mar 25, 1986 · N22613 · Substantial damageNTSB LAX86LA153Accident · No injuriesLimited investigationFinal reportCessna 172N · Lakeport, CAWitnesses reported that they observed the plt make 2 approaches and landings prior to the accident. On the landing just before the accident, they observed an 'extremely hard landing on the nose gear.' They reported that the plt then taxied back to takeoff…Mar 25, 1986 · N4863F · Substantial damageNTSB FTW86LA048Accident · No injuriesLimited investigationFinal reportBeech H35 · Talihina, OKAcft had a long descent from cruise alt of 7500' MSL at reduced power setting due to plt's desire to avoid the moderate turbulence at lower altitudes. On short final, over tall trees, the acft encountered a downdraft. The plt stated that when he applied power…Mar 25, 1986 · N5531D · Substantial damageNTSB DEN86LA104Accident · No injuriesLimited investigationFinal reportChampion 7GCAA · Falcon, COAccording to the plt, when the acft slowed after landing, it turned 'sharply to the right.' The plt stated he experienced 'extreme tailwheel shudder' prior to this during the landing roll. During the investigation, it was ascertained that the tailwheel spring…Mar 25, 1986 · N9614S · Substantial damageNTSB ATL86LLT08Incident · No injuriesFinal reportPiper PA-34 · Smithville, TNThe acft ran off the departure end of the rwy during landing. The acft reportedly landed 1/2 way down the 3400 ft rwy. The plt stated in a post acc interview that he was 'too high too fast and too long.'Mar 25, 1986 · N3951X · Minor damageNTSB ATL86LA101Accident · No injuriesLimited investigationFinal reportCessna 172N · Advance, NCWhile on final apch to rwy 27,plts vision restricted by sun glare. Plt indicated that he was high & fast and landed too long to allow go around. Overran runway, nose gear mired and acft nosed over.Mar 25, 1986 · N737DR · Substantial damageNTSB MIA86FA103Accident · Serious injuriesField investigationFinal reportPiper PA-23-250 · Osteen, FLBefore the flt, the plt & pax were observed drinking alcoholic beverages on the way to the arpt. After much difficulty taxiing to the rwy, the flt was cleared for takeoff after entering the active rwy without clearance. After taking off, the acft was seen…Mar 24, 1986 · N77TS · Substantial damageNTSB LAX86LA152Accident · No injuriesLimited investigationFinal reportCessna C-152T · Fresno, CAA Cessna 152 collided with terrain after running off rwy 29L. The plt indicated he made a go-around on first approach due to difficulty maintaining rwy heading. On second approach he was aligned a little left of centerline and elected to land. The acft…Mar 24, 1986 · N49420 · Substantial damageNTSB DEN86FA103Accident · 2 fatalField investigationFinal reportI.C.A. Brasov IS-28B2 · Cedar City, UTThe plt and pax were returning from a LCL flt. Two fss specialists observed the glider on final approach to rwy 20. They stated that the acft completed two 360 degree turns with 90 degrees of bank. The glider was in the third 360 degree turn when the…Mar 24, 1986 · N32907 · Substantial damageNTSB ANC86LA041Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Fairbanks, AKThe flight instructor stated that he was demonstrating a stall landing to the student pilot. After touchdown and rollout the aircraft struck a snow drift on the runway causing the aircraft to nose over on its back.Mar 24, 1986 · N7145K · Substantial damageNTSB NYC86LA089Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Danbury, CTPilot touched down long on 3135 foot runway, exceeding the braking action of the aircraft, ran off end of runway into a ditch causing substantial damage to the aircraft. The pilot, the sole occupant received no injuries.Mar 23, 1986 · N80021 · Substantial damageNTSB NYC86FA092Accident · Minor injuriesField investigationFinal reportAerospatiale AS350D · Philadelphia, PAA Aerospatiale helicopter an a-star under FAR 135 with pilot and 4 passengers onclimb out reaching an altitude of approx 100 to 150' AGL when pilot and passengers heard a loud bang acft lost power. Pilot attempted an auto rotation, due to low airspeed and…Mar 23, 1986 · N512WW · DestroyedNTSB MIA86LA102Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Hollywood, FLThe plt stated that while flaring to land, a gust of wind picked up his right wing & before he could recover he lost control & the acft ground looped.Mar 23, 1986 · N9169T · Substantial damageNTSB LAX86LA155Accident · No injuriesLimited investigationFinal reportBell 206B · Huntington Bch, CAA Bell 206B collided with a berm after an eng failure while departing a helipad. The plt indicated he had just departed the helipad at night and at aprx 50 ft AGL the eng failed. The acft vertical fin hit the berm causing the tail boom to bend aft of the…Mar 23, 1986 · N49643 · Substantial damageNTSB LAX86FVM04Accident · Minor injuriesFinal reportQuickie II · Watsonville, CAThe acft landed in a wet field off the departure end of the takeoff rwy after the engine lost power during takeoff. The acft nosed over during the landing. The owner reported that the carb heat was on at the scene of the accident. The plt does not remember…Mar 23, 1986 · N3921V · Substantial damageNTSB LAX86DVA04Accident · 1 fatalFinal reportGlen Davis Glasair · Chinese Camp, CAA glasair homebuilt aircraft collided with a barn shortly after takeoff on a night time business trip. The aircraft departed from the extreme left side of the runway which had a high growth of vegetation. The aircraft was observed to be about 40 to 50 ft…Mar 23, 1986 · N84GD · DestroyedNTSB DEN86LA102Accident · No injuriesLimited investigationFinal reportDouglas C-47 · Steins, NMWhile en route, the left eng of the C-47 lost partial pwr as a result of a cracked cylinder. The crew stated the left eng was shut down and additional pwr was applied to the right eng to compensate for the increasing rate of descent. The crew stated a short…Mar 23, 1986 · N37AP · Substantial damageNTSB CHI86LA107Accident · No injuriesLimited investigationFinal reportNavion H · Columbus, INThe pilot was practicing a short field takeoff when at 30 to 40 feet the engine lost power and quit, the aircraft subsequently landed hard damaging the right landing gear box and fuselage behind the right wing. The pilot said he may have taken off on the tip…Mar 23, 1986 · N25342 · Substantial damageNTSB CHI86FEE01Accident · Minor injuriesFinal reportCessna 172 · Marseilles, ILThe takeoff was being made from an arpt which is on the grounds of a golf course. During takeoff the nose wheel struck the raised terrain of a golf tee located aprx 75 ft left of the rwy 18 centerline and 1000 ft from the departure end of the rwy. The plt…Mar 23, 1986 · N97266 · Substantial damageNTSB CHI86FA108Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Boyne Falls, MIAfter the plt was cleared for an rnav-b apch, the acft crashed on hilly trrn aprx 3 mi se of the arpt at an elev of 750'MSL. Impact occurred after the acft had turned to the sse & was dscndg. Min dscnt alt (mda) for the apch was 1680'. No preimpact mechanical…Mar 23, 1986 · N43769 · DestroyedNTSB NYC86LA090Accident · Minor injuriesLimited investigationFinal reportBeech S35 · Laconia, NHDuring cruise flt, the acft eng failed & oil covered the windshield & side windows. Subsequently, the acft crash landed into wooded terrain while in a wings level attitude at low speed. Tests showed the eng crankshaft had failed from fatigue. The fatigue…Mar 22, 1986 · N5629K · Substantial damageNTSB NYC86LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Springvale, METhe Piper cherokee PA-28-140 lost power and made an off airport landing 15 minutes after takeoff. The pilot reported an oil line broke and he lost all engine oil. A mechanic reported that there was no indication in either the engine compartment or the bottom…Mar 22, 1986 · N4211T · Substantial damageNTSB NYC86LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Hartford, CTThe cross country solo flight was taking off on runway 02 at Hartford, Connecticut. The pilot performed a runup and was cleared for takeoff. The pilot attempted rotation at about 60 KIAS, but aircraft did not lift off. Trim tab was set at neutral on runup. As…Mar 22, 1986 · N4347G · Substantial damageNTSB NYC86LA086Accident · Minor injuriesLimited investigationFinal reportTaylorcraft BC12-D · Tioga, NYThe pilot decided to make an off airport landing after becoming confused as to his exact location. During the landing a wind from the right caught the aircraft and it drifted left into trees. The pilot stated he had VFR sectional charts with him at the time…Mar 22, 1986 · N43529 · Substantial damageNTSB MKC86LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Oil Trough, ARThe PIC found himself low on fuel with an indication of only 5 gallons in each tank. He passed over an arpt with fueling facilities available but diverted to batesville, Arkansas, which lay 48 miles beyond his present posn. The PIC stated that he attempted a…Mar 22, 1986 · N30561 · Substantial damageNTSB MKC86LA071Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Neosho, MOThe pilot stated that he had descended from 5500 feet MSL to 2000 feet MSL with the throttle at idle and without using carburetor heat. When he advanced the throttle, the engine did not respond and he attempted a forced landing. The airplane impacted trees,…Mar 22, 1986 · N1017X · Substantial damageNTSB LAX86MA151Incident · No injuriesMajor investigationFinal reportBoeing 727-231 · Cincinnati, OHIndianapolis ctr (ctlr-a) clrd sluff 11 (S-11), a flt of 4 ANG A-7'S, to clb to FL210. Later, ctlr-a told S-11 to chg freq (to york low sector, ctlr-b). S-11 chgd freq, but neither S-11 nor ctlr-b established rdo contact with each other until S-11 had contd…Mar 22, 1986 · N64315 · 2 aircraft · No damageNTSB FTW86LPA16Accident · No injuriesFinal reportCessna 188 · Atlanta, TXThe pilot lost directional control of the aircraft during the landing roll. It then departed the runway and ran into a drainage ditch which collapsed the main landing gear.Mar 22, 1986 · N6009G · Substantial damageNTSB FTW86FA046Accident · 1 fatalField investigationFinal reportCessna 120 · Whitefield, OKThe pilot was flying at very low altitude while circling the area and most probably did not see the powerline, due to sunglare, until at very close range. He then pulled up steeply in the strong and gusty headwind and stalled the aircraft without sufficient…Mar 22, 1986 · N77483 · DestroyedNTSB ATL86FA097Accident · 2 fatalField investigationFinal reportRobinson R-22 · Memphis, TNA loss of control in flight for undetermined reasons.Mar 22, 1986 · N9069S · DestroyedNTSB ANC86LA040Accident · No injuriesLimited investigationFinal reportCessna 170-B · Whittier, AKThe pilot stated that after touchdown he realized that the snow was soft. The aircraft nosed over on its back.Mar 22, 1986 · N1999C · Substantial damageNTSB ANC86LA039Accident · No injuriesLimited investigationFinal reportCessna 172-G · Anchorage, AKThe plt stated that during the return from a x-country flt the acft ran out of fuel one-half mile from the rwy. Post acc exam revealed that both fuel tanks were empty.Mar 22, 1986 · N5892B · Substantial damageNTSB SEA86LA081Accident · No injuriesLimited investigationFinal reportAir Tractor 301 · Prescott, WAThe brake locking system engaged in flight causing the right brake to lock. The aircraft nosed over on landing where a small fire erupted from fuel spillage onto the hot engine.Mar 21, 1986 · N5097S · Substantial damageNTSB MKC86LA072Accident · No injuriesLimited investigationFinal reportJim Elliott VP-2 · Scott City, KSThe plt was making his first flt in the acft which is powered by a volkswagon, 1,834 cc eng. The acft became airborne from a hard surface rwy and climbed to about 100 ft AGL. The plt said the controls felt mushy and when he attempted to climb the airspeed…Mar 21, 1986 · N32JE · Substantial damageNTSB LAX86LAMS1Accident · 1 fatalFinal reportCessna U206C · Maunaloa, HIWhile on an inter-island cargo flight conducted under 14 CFR 135, the pilot reported to the honolulu ARTCC that the airplane was experiencing a loss of propeller RPM; he did not report that the engine was losing power. The airplane crashed into the pacific…Mar 21, 1986 · N144FP · DestroyedNTSB LAX86LA149Accident · Serious injuriesLimited investigationFinal reportCessna T210N · Phoenix, AZThe pilot was practicing instrument approaches and reported to the control tower that he had experienced a loss of engine power. During the attempted forced landing, the aircraft struck power lines and crashed inverted in a river bed two miles west of the…Mar 21, 1986 · N5256A · Substantial damageNTSB LAX86FVM03Accident · No injuriesFinal reportBeech 65-A80 · Cuyama, CAThe acft contacted two cows while operating along the side of a road in a remote area. Vehicle tracks were found near the wreckage, however, no persons were found at or near the wreckage. Trained drug sniffing dogs were used at the accident site and it is…Mar 21, 1986 · N29DS · Substantial damageNTSB LAX86FVG02Accident · No injuriesFinal reportSikorsky S-55 · Afton, CAThe acft was landed off the arpt in a forced landing after a pwr loss. The acft was damaged in the hard landing. Eng teardown showed the r/h magneto model S7LV-2 had stripped distributor drive gears. No other abnormalities noted. The TSO of the mag was…Mar 21, 1986 · N8327 · Substantial damageNTSB FTW86LA072Accident · No injuriesLimited investigationFinal reportCessna R172K · Waco, TXThe pilot of a Cessna 172, N758KU, over-shot his approach to a privately owned grass strip. The runway is 05/23, 3180 foot long and 100 foot wide with an approximate 300 ft. displaced threshold at east end. The wind was variable from 300 degrees at 8 knots at…Mar 21, 1986 · N758KU · Substantial damageNTSB DEN86FA101Accident · Serious injuriesField investigationFinal reportPiper PA-32R-300 · Albuquerque, NMThe acft crashed on the second aborted takeoff attempt. The plt said that the acft was not accelerating properly on the first attempt and that the eng lost power on the second attempt. Ground witnesses said that the air conditioner condenser door was open and…Mar 21, 1986 · N555EB · DestroyedNTSB CHI86LA109Accident · No injuriesLimited investigationFinal reportCessna 152 · Wonder Lake, ILThe starter would not engage, so the plt tied down the tail & hand propped the acft to start the eng, but did not use chocks. After the eng started, the acft rolled forward, slipped loose from the rear tie-down & ran into a pile of i-beams. A post acdnt exam…Mar 21, 1986 · N49421 · Substantial damageNTSB ATL86IA100Incident · No injuriesIncident investigationFinal reportBoeing 737-200 · Nasville, TNA nr midair collision occurred aprx 38 mi se of the nashville metro arpt as a Boeing 737, piedmont flt 488, was dscndg thru aprx 12,000' & a flt of 4 F-4'S, call sign peach 41, were joining. Flt 488 was inbnd to nashville on an IFR clnc & memphis ARTCC had…Mar 21, 1986 · N774N · 2 aircraft · No damageNTSB ATL86FLT05Accident · No injuriesFinal reportPiper PA-14 · Memphis, TNThe acft collided with an air compressor and a hangar door during taxi after the plt hand-propped the unoccupied acft. The ptl said that the thought the 'switches were off'.he was pulling the prop to 'loosen' the oil when the eng started and the acft started…Mar 21, 1986 · N4276H · Substantial damageNTSB ANC86LA038Accident · No injuriesLimited investigationFinal reportCessna 180J · Anchorage, AKThe pilot stated that during the takeoff roll he added power too fast for the takeoff. The pilot failed to compensate with rudder.Mar 21, 1986 · N46362 · Substantial damageNTSB NYC86LA091Accident · No injuriesLimited investigationFinal reportCessna 140 · Newburyport, MAWhile taxiing on a grass taxiway, the acft contacted a soft spot in the grass and nosed over.Mar 20, 1986 · N2643N · Substantial damageNTSB NYC86IA109Incident · No injuriesIncident investigationFinal reportSikorsky S-76 · Atlantic City, NJDuring a preflight examination of a Sikorsky S76 the instructor and student discovered a hole in the leading edge of the pylon above the intermediate gear box and scuff mark on the main rotor blade caps. The instructor and student had just completed a 2.1 hr…Mar 20, 1986 · N38 · Minor damageNTSB LAX86LA148Accident · No injuriesLimited investigationFinal reportCessna 140 · Rio Linda, CAOn March 20, 1986, a Cessna 140 nosed over in mud after running off runway 17. VMC prevailed at the time. The aircraft was substantially damaged and the pilot and his passenger were not injured. The pilot stated he was too fast on his approach and ran off the…Mar 20, 1986 · N89698 · Substantial damage