FAA incident reports
234,323 FAA reports of aviation accidents and incidents, from the FAA’s Accident/Incident Data System (AIDS) through its Aviation Safety Information Portal. An incident falls short of an accident: a bird strike, say, or a gear-up landing without substantial damage. The NTSB investigates accidents separately, and its record of an accident is the fuller one.
Reports, newest first
Query with SQL
duckdb -csv -c "SELECT report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet' ORDER BY event_date DESC, report_number 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 report_number, event_date, event_type, city, state, aircraft_make, aircraft_model, aircraft_damage, fatal_injuries, n_number FROM 'https://openairdocs.org/data/latest/faa_incident_report.parquet' ORDER BY event_date DESC, report_number 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.
Accident 19991219037579ABeech E90 · Beaufort, SC(.19) On December 19, 1999, at about 2035 eastern daylight time, a Beech E-90, N75CF, registered to the university of south carolina athletic department, operating as a 14 CFR part 91 positioning flight, crashed during an area surveillance radar approach to…Incident 19991219037469IBeech V35 · Jacksonville, FL(-23) On December 19, 1999, at 14:04 EST, Mr. David f. scales, pilot in command, was flying his Beechcraft V35 bonanza, N6262V, on an instrument flight rules (IFR) cross country flight from the jackson county airport (19A), Georgia to the Jacksonville…Incident 19991219036479ICessna 421B · Dallas, TX(-23) No narrative.Incident 19991219035639IBoeing A75N1 · Baltimore, MD(-23) During normal banner towing operations the tow rope released, without pilot manually releasing it. The banner and tow line landed in the parking lot of PSI net stadium, slight damaging an unoccupied car. The hitch and release mechanism was inspected and…Incident 19991219035009IAmtr 111MCASSUTT · Leavenworth, KS(-23) Mr. Parked experienced a rough running engine near lansing, KS, just south of Leavenworth, KS, and made a precautionary laning in a farmer's field. Damage to the aircraft was minor, and there were no injuries. He stated that the aircraft does not have a…Incident 19991219034749IMooney M20J · Bedford, MA(-23) This aircraft touched down on Bedford runway 29 approx 365 feet short of the painted runway threshold at 1900 sat. 12-19-99. The aircraft did a touch and go and went around. After making another touch and go it landed without further incident. I…Accident 19991218043259AHughes 269A · Brownsboro, TX(-23) Pilot was conducting aerial surveillance of creek bed at low altitude and airspeed. Following creek bed the pilot turned the a/c into an easterly direction. Wind reported at tyler airport was 32007. Once in a downwind condition pilot experienced a…Accident 19991218042239ACessna 172F · Fort Worth, TX(.4) While performing a touch-and-go landing, the solo student pilot allowed the airplane to touch down nose wheel first, and the airplane porpoised. Subsequently, the airplane bounced a second time, departed the runway, struck the right wing against the…Incident 19991218041549IAmtr P51THREQUART · Greenville, SC(-23) On December 18, 1999, at approximately 1230 hours, the pilot was conducting a high speed taxi check on the aircraft whe the pilot's seat back became loose and shifted aft causing a loss of control of the aircraft. The aircraft then went off the runway.…Incident 19991218041169IMaule M4 · Cincinnati, OH(-23) While en route from madson county airport (uyf) to greater Cincinnati airport (cvg) [privacy data omitted] aircraft began to loose power. The power dropped from 2500 RPM to 2300 RPM, and then to idle. [privacy data omitted] Tried to switch fuel tanks…Accident 19991218040649ABeech A23 · Blacksburg, VA(-23) On December 18, 1999, at Virginia Tech (bcb) Blacksburg, Virginia, while approaching to land, the aircraft bounced 3 (three) times and then came down hard on the nose gear which then collapsed, causing the propeller to strike the runway. A fire then…Accident 19991218040269ACessna 152 · Hickory, NCPilot was doing soft field training with student. Student did a go-around. CFI did two missed approaches, landed and taxiied back on runway for an uphill take-off. CFI started to lose control during take-off roll. He decided to abort the take-off, then…Incident 19991218037759ICessna 337G · Dallas, TX(-23) Mr. Slaton took off with CFI MEI richard miller & 1 passenger on 12/18/99 at approximately 16:00 CST. Upon takeoff, Addison tower notified the pilot that the rear engine was not operating. The aircraft was set down on the property at the north end of…Incident 19991218037519IAmtr FLIGHTSTAR2 · Garden Ridge, TX(-23) On takeoff at 300 ft ultralight experienced a down draft causing it to stall and loose altitude. At 150 ft. pilot deployed safety chute.Accident 19991218037069AAmtr VELCITY173FG · Murfreesboro, TN(.19) On December 18, 1999, at about 0917 central standard time, a swertfeger velocity 173 elite, experimental homebuilt airplane, N627KB, registered to a private owner, operating as a 14 CFR part 91 personal flight, crashed while on approach to Murfreesboro…Accident 19991218036879ACessna 172A · Shoshone, CA(.19) On December 18, 1999, at 1130 hours pacific standard time, a Cessna 172A, N34261, veered off the runway and collided with a bush while landing on runway 33 at the Shoshone, California, airport. The airplane, owned by the pilot's wife, sustained…Accident 19991218036709AAmtr KR2 · Moreno Valley, CA(.19) On December 18, 1999, at 1210 hours pacific standard time, a homebuilt experimental rhea KR-2, N77KR, experienced a loss of engine power and force landed in a parking lot in Moreno Valley, California. The aircraft, owned and operated by the pilot, was…Incident 19991218035659IBeech 95 · Taos, NM(-23) On December 18, 1999 at approximately 2430, Mr. John raymond bode, was attemptint to move his aircraft, a Beechcraft travel air (BE-95-95), N652Q, from in front of the Taos Municipal Airport (old) terminal building to a tie down area for the night. When…Incident 19991218035559IBoeing 727221 · Boston, MA(-23) N367PA, a B-727, operated by pan American airways was struck by a hudson General fuel truck while parked at gate 1D, terminal d. no crew members or pax were on board at the time. The driver of the fuel truck, apparently suffered a brake failure while…Accident 19991217046279ADoug DC862 · Indianapolis, IN(-23) Aircraft was parked on spot B4C. Evergreen ground control gave taxi instructions to taxi off spot B4C to box 2 following the greeen dotted line. Ground marshaller gave the move forward signal, having the aircraft make an immediate left turn bringing the…Accident 19991217046269AAmtr EXEC90 · Georgetown, IN(-23) Pilot attempted to hover with a strong tailwind and a forward CG. Aircraft nose pitched down with pilot applying full aft cyclic. Left skid contacted ground and aircraft rolled over onto its left side.Incident 19991217045319IPiper PA34200T · Limon, CO(-23)Unable to contact aircraft owner by phone or letter to deterine who was operating the aircraft and determine cause of power loss. Attempts continuing and if successful will update.Accident 19991217045189ACessna 172N · Concord, CA(.4) On December 17, 1999, at 1024 hours pacific standard time, a Cessna 172N, N738UA, operated by the pilot was substantially damaged during a takeoff attempt at Concord, California, when it ran off the departure end of the runway and collided with a fence.…Accident 19991217043159ABeech 35BEECH · MI(-23) On December 17, 1999 while cruising at 2500 feet from owb to 29C aircraft N5BB engine sputtered and fuel flow flunctuated. The engine quit and could not restart using the other fuel tanks and wobble pump. Upon landing in the field the nose gear dug in…Accident 19991217041669AMooney M20J · New Milford, CT(.4) The airplane experienced a propeller strike, and the engine was sent for a teardown inspection. The engine was reinstalled and then run for 0.4 hours. The pilot conducted a preflight, started the engine, and taxiing to the runway. A run-up check was…Accident 19991217041369APiper PA32RT300 · Geneva, AL(.4) According to a pilot witness, the pilot had difficulty starting the aircraft engine. The witness stated that the engine coughed and sputtered and black smoke was coming from the exhaust. Once the engine started, it ran smoothly. The pilot taxied to…Accident 19991217040599ABeech B95A · Big Lake, TX(-23) During an aborted landing go-around attempt, the a/c lost power and directional control. The a/c struck a utility pole engulfing the left wing in fire from the ruptured fuel tank. The a/c struck a second set of power lines and crashed in a residential…Incident 19991217040149IBoeing 737823 · Chicago, IL(-5) Pilots filed under asap program approved by American in accordance with company procedures. Ord-fsdo incident investigation closed. No further action required.Incident 19991217038799ICessna 172S · Indianapolis, INOn December 17, 1999, at approximately 1510 EST, a Cessna 172SP, N2373Z piloted by a student pilot on a supervised solo flight, experienced a hard landing in light crosswind conditions on runway 33 at Indianapolis meteropolitan airport (kump). During the…Accident 19991217037159ACessna 172S · Houston, TX(.19) On December 17, 1999, at 1354 central standard time, a Cessna 172S airplane, N912JR, was substantially damaged when it impacted a taxiway light and a ditch while landing at the Sugar Land municipal airport, Sugar Land, Texas. The student pilot, sole…Incident 19991217035909IEMB EMB120ER · Santa Barbara, CA(-23) On 12/17/1999 at 0710, skywest flight 5420 diverted into sba with smoke and fumes in the cockpit. Lax maintenance responded and found the right engine P3 2.5 switching valve stuck. Maintenance control defered the valve iaw MEL procedures, MEL 75-32-2A,…Incident 19991217034899IPiper PA34200T · Fredricksburg, TX(-23) The valve stem failed on the right main tire causing the tire to go flat.Incident 19991217034889IBag JETSTM3101 · Pittsburgh, PA(-23) On December 17, 1999, 1 BA-jtstrm-3101, registered as N837JS, s/n 736, operating as chqa flight 9482 (op's reposition) landed without incident at pit runway 28R and taxied to the gate. The aircraft had no down and locked indication for the landing gear.…Accident 19991216047839ABeech N35 · Englewood, CO(-23) On December 16, 1999, at 1501 MST, a Beech N-35, N9468Y, landed approximately 1 mile short of the runway at centennial airport, Englewood, CO, following a complete loss of power. There were no injuries. (.4) during descent in preparation for landing at…Incident 19991216038349ICessna 182P · Katy, TXPilot stated on his second flight of the day, the engine lost power and he made a forced landing in a feild next to his air strip. On landing, the left edges, horizontal stabilizer leading edges and nose gear wheel fairing. Inspection of the fuel system…Accident 19991216037679APiper PA31T1 · Santa Fe, NM(.19) On December 16, 1999, at 1515 mountain standard time, a Piper PA-31T1, N919RD, impacted terrain during initial climb following takeoff from Santa Fe, new Mexico, after a partial power loss. The private pilot and his two passengers received minor…Accident 19991216036969AN121CC · Olney, TX(.19) On December 16, 1999, at 1045 central standard time, a cartercopters cartercopter gyroplane, N121CC, registered to and operated by cartercopters LLC of witchita falls, Texas, was substantially damaged during landing at the Olney Municipal Airport near…Incident 19991216036079IPiper PA34200T · Sylvania, GA(-23) Pilot landed aircraft hard and turned fast and the right landing gear collapsed.Incident 19991216034119IBag JETSTM3201 · Fresno, CA(-23) During final approach into Fresno Yosemite int'l airport (fat), the number 1 engine was shut down due to an illuminated "low fuel pressure" light and fuel discharging from the lower area of the engine. After landing, the crew and passengers egressed…Accident 19991215044969ACessna P210N · Bridgeville, DE(-23) The a/c struck trees on departure from a rain soaked grass runway. The weather was reported by the nearest fss to be 800 feet overcast and 1 mile visibility. The a/c sustained substantial damage with no injuries to the pilot or passenger. The pilot will…Accident 19991215044409ACessna 140 · Helena, MT(-23) On December 15, 1999, at approx. 1530 MST, a Cessna 140, N2739N sustained substantial damage when it nosed over during landing roll at the silver city airstrip, about 18 miles northwest of Helena, Montana. The pilot stated that on his second…Accident 19991215042819AHughes 369D · Colorado Spring, CO(-23) The helicopter experienced tail rotor failure resulting in a rotational right hand spin contacting the ground.Incident 19991215038609IGulstm 560 · Kenosha, WIWhile landing on runway 6L after reduction pilot felt the right wing drop. Pilot attempted to correct with aileron. Aircraft landed hard. Post landing inspection revealed minor damage to right wing tip.Incident 19991215038599IAMD FALCON20 · Detroit, MIAfter takeoff from jvl the crew noticed that the door open light was illuminted with the handle up. The crew made a decision to proceed to yip with the gear down. The crew performed a fly by with maintenance personel observing and the ok was given to the crew…Incident 19991215037809ICessna 172N · Indianapolis, IN(-23) On 12/15/99 at 0100 local time fedex, N468FE a B-727 was number 1 for takeoff and a CE-172-N, N737LJ was behind fedex, number 2 for takeoff. Both acft were on taxiway D-1 for departure on rnwy 23L. Fedex was instructed to take position and hold on…Accident 19991215036889AMaule M7235C · Iuka, MS(.19) On December 15,1999, at 1516 central standard time, a Maule M7-235, N4AN, ground looped during landing at the Iuka Airport in Iuka, Mississippi. The aircraft was operated by the private pilot under the provisions of title 14, CFR part 91, and visual…Incident 19991215035699IDoug MD88 · Reno, NV(-23) 12/15/1999, Midwest express flight 921 departed sfo direct mke. 2202Z, at 33,000 ft cruise altitude over central Nevada, the flight crew experienced a vibration in the flight controls and aircrame. The captain was alerted by one of the flight attendants…Incident 19991215035609IJetair JETSTM4101 · Rochester, NY(-23) On Wednesday, December 15, 1999 at 1752 local, a trans states airlines (d/b/a delta connection), jetstream 4101, N554HK landed on runway 22 at Rochester international airport after reporting a right engine failure. The flight crew reported that the…Incident 19991215034869IDhav DHC8102 · Providence, RI(-23) Allegheny flight 3637 struck a ramp boundary fence with the left wing while taxiing in a non-movement area at pvd. Visibility was marginal and the pilot struck the fence while attempting to provide clearance for taxiing aircraft. Improper reflector…Incident 19991215033919IBoeing 72746 · Louisville, KY(-23) On December 15, 1999 at 2330 EST, a Boeing 272, N190AJ, registered to northern air cargo collided with ground support equipment while taxiing under the direction of a ground marshaller. Visual meteorological conditions prevailed at the time. The…